On Tue, May 19, 2015 at 10:31 PM, Greg Sabino Mullane <greg@turnstep.com> wrote:
If you are running into situations where you have question mark operators in your queries, you have already lost the query abstraction battle. There will be no seamless switching if you are using jsonb, hstore, ltree, etc.
Actually, no, you haven't quite lost that battle, or rather, that battle doesn't even need to take place.
You can still use common tools for operations that are not really RDMBS-specific AND use PostgreSQL extensions on a case-by-case basis depending on your application requirements.
Some of these tools already allow you to tweak slightly their capabilities by implementing dialects, and let you use specific features if required.
I think this is a major advantage of having these extensions in PostgreSQL: you can have the best of both worlds. It's not so much about being able to switch to another RDMBS, it's about not having to re-implement the bulk of the structure when you just want to benefit from a few additional extensions (for example, mixing the classic RDBMS model with the JSON store model).
