Failed query validation by use of postgreSQL string_agg() function
In AQB Version 3.5.x I can use a postgreSQL string_agg() function within my sql and it worked. Now I had to add an order by to the string_agg() function. I got an error message about this unknown feature. So, I updated AQB to the current version 3.9.x. Now the effect is, that the sql parser eliminates the word "string_agg" out of the sql and generates a column with the parameters in brackets.
The correct function call is: string_agg(column, delimiter order by column)
How can this behavior be corrected?
thank you for report, it was a bug in SQL text emitting code, now it is fixed upstream, and the fix will be included in the next release.