mo-sql-parsing
mo-sql-parsing copied to clipboard
klahnakoski
Let's make a SQL parser so we can provide a familiar interface to non-sql datastores!
SQLServer identifiers (eg `[this is a column name]`) conflict with BigQuery's Array constructor (eg `[1, 2, 3, 4]`). Can a good guess be made about which flavour we are parsing?
As per https://github.com/klahnakoski/mo-sql-parsing/issues/248: > These are operators so the problem is actually more generic, since it is possible to define new operators: > https://www.postgresql.org/docs/current/sql-createoperator.html > > For instance this works...
This works in PostgreSQL 16: ``` create view public.delete→me as (select 42); select * from public.delete→me; ``` So I expected this to work as well: ``` from mo_sql_parsing import parse...
Metadata
Owner
Metadata
Let's make a SQL parser so we can provide a familiar interface to non-sql datastores!