Michael Toy
Michael Toy
1. A dialect can be marked "experimental" 2. Compiler will error if a connection with an experimental dialect is used without `##! experimental.dialect.DIALECT_NAME` - [ ] Allow tests to use...
Apparently that isn't an operator for bigquery so we need to introduce dialect specific translation for `%`
``` run: duckdb.sql(""" SELECT 1 as n, false as even UNION ALL SELECT 2, true UNION ALL SELECT 3, false UNION ALL SELECT 4,true """) -> { group_by: even nest:...
``` run: duckdb.sql("SELECT DATE '2001-01-01' as d1, DATE '2002-01-01' as d2") -> { select: diff_days is d2-d1 } ```
TImes got left in a weird place when the timezone work was finished because there wasn't good clarity on the right thing. Now there is clarity. Make the malloy gestures...
Proposal is something like ``` #XXXYYY multilinetex XXX ``` where XXX is something like `|` or `*` and YYY is the annotation/type/route thing ``` #| plot { ... } ```...
``` source: has_tstz is postgres.sql("SELECT current_timestamp as a_tstz") query: rows is has_tstz -> { select: the_time is a_tstz } run: rows -> { limit: 1 select: the_time } ``` `rows`...
``` run: bigquery.sql(""" SELECT DATE '2001-01-01' as join_date, DATE '2001-02-01' as expiry_date """) -> { select: round_wrong is round(days(join_date to expiry_date)) no_round_right is days(join_date to expiry_date) } ```  The...
``` run: duckdb.sql("SELECT DATE '2001-01-01' AS dstart, DATE '2002-02-01' AS dend") -> { select: dstart, dend, ddiff is months(dstart to dend) } ``` Errors with `Cannot measure interval using 'month'`...
`exclude(expr, dimension_name)` in an aggregate statement is checked at compile time, and if the dimension is not a grouping file for the query operation, or a query operation this query...