BI tools all generate SQL with varying levels of optimization. However, do
any of you know of any BI tools that are more PostgreSQL aware in that they
can generate queries that take advantage of extensions like hstore, arrays
etc?
Hstore and JSON data types use non-standard syntax within PostgreSQL - not
that I know of anything in the SQL standards that say how to handle KV
types in the style of hstore.
Which BI tools, if any, either are aware of PostgreSQL in this way or at
least minimize hindrances to using these types of data types or extensions?
- Victor Tan