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