Re:The SQL filter clause: selective aggregates
by smt88 on Monday May 30, 2016 @07:37PM
(#11803805)
> Relational expressions are converted into equivalent SQL and passed back to the Postgres SPI interface for execution
I actually don't think I like that approach.
If I transpile my own queries (meaning I use a query builder), then I can cache the generated SQL. There would be some placeholders for arguments, but the query itself doesn't change.
Andl's approach could add significant overhead in certain applications where lots of queries are being executed at once.
And then what happens to EXPLAIN support? Is it harder to debug an Andl query?
I actually don't think I like that approach.
If I transpile my own queries (meaning I use a query builder), then I can cache the generated SQL. There would be some placeholders for arguments, but the query itself doesn't change.
Andl's approach could add significant overhead in certain applications where lots of queries are being executed at once.
And then what happens to EXPLAIN support? Is it harder to debug an Andl query?