I've been playing for a long while with aura/sqlQuery and it's quite good to build sql queries.
Today I would like to see some support added for google BigQuery's standard SQL. The basic implementation would be very straightforward, as the name says it's standard sql, so for the most part it should be easy to implement using default classes. Maybe it would need some special things to have support for UNNEST feature when using fromSubSelect
Hey there,
I've been playing for a long while with aura/sqlQuery and it's quite good to build sql queries.
Today I would like to see some support added for google BigQuery's standard SQL. The basic implementation would be very straightforward, as the name says it's standard sql, so for the most part it should be easy to implement using default classes. Maybe it would need some special things to have support for
UNNEST
feature when using fromSubSelectHowever what would be very convenient would be to add support for
over
,partition by
andwindow
clauses.If that's something you would like to see implemented in the library, I'm ready to do the work by myself.