> ...field-level encryption should be a starting place for new application development...

What does the state of the art look like here? Particularly when it comes to familiar tech like Postgres and Redis?

> Conversely, this will generally be a pain to work with ... (You can, of course, build something like a trigger to allow retrieving the keys within the database, but that would significantly undermine the value of this entire enterprise.)

Is this limitation inherent to the concept, or are there some creative ways to retain the benefits without having to lose the relational aspect of the DB?