The first time I tried to use the database tools integrated into PhpStorm (which are the same as the ones in IDEA), their SQL parser stumbled over PostgreSQL's

The first time I tried to use the database tools integrated into PhpStorm (which are the same as the ones in IDEA), their SQL parser stumbled over PostgreSQL's ::type cast (try "select '2014-01-01'::date") and the next time I tried it, it stumbled over a CTE and failed to parse the rest of the query. Yes. Both are simple bugs (I reported one of them, the other would be very difficult to reduce the test case for), but if I need a tool that's more advanced than plain psql, then it's for the big and complicated queries which this tool apparently isn't made for. It's fine if it's a plugin for an otherwise mostly unrelated IDE (like in the case of PhpStorm, RubyMine or IDEA), but it's not at all acceptable if it's the main feature of a product. As such we'll see which one happens: Either they make their database support arbitrary queries or their tool will just fail in its biggest use case (being a tool for the complicated queries where the text editor/native tool combo isn't sufficient.