Justin True comments

Repositories
Issues
Comments

Results 3 comments of


                                            Justin True

How to set Snowflake dialect for all method calls

this seems like valid sql for snowflake. is there an exception thrown from the DB? for a workaround, I think you can override the double-quotes like this: `q.get_sql(alias_quote_char='')`

Create a Postgres array ordered by some criteria

I would just create my own version of `array_agg` as a pypika aggregate function. Something like this should work. Overriding the `get_function_sql` method lets you put anything you want in...

Use of aliased tables in functions generates incorrect SQL

Hi @davidpurser, Besides the table alias you can also pass `*`, any literal, any field and other terms in most RDBMS. Have you tried passing anything else? This should work...