4 ms·
Somewhat similar, see https://substrait.io/ https://substrait.io/ So for example using DuckDB with the Substrait extension, if you create a table create t
by chrisjc 3y ago
Somewhat similar, see https://substrait.io/ https://substrait.io/
So for example using DuckDB with the Substrait extension, if you create a table
create table t(a int);
and then query it as in the article, you can see something similar to what is described in the article
CALL get_substrait_json('select * from t');
{"relations":[{"root":{"input":{"project":{"input":{"read":{"baseSchema":{"names":["a"],"struct":{"types":[{"i32":{"nullability":"NULLABILITY_NULLABLE"}}],...
DuckDB extension doesn't seem to cover any DDL operations though.
https://duckdb.org/docs/extensions/substrait https://duckdb.org/docs/extensions/substrait
Some other related discussions and links that i've collected over the years
https://news.ycombinator.com/item?id=37415494 https://news.ycombinator.com/item?id=37415494
https://news.ycombinator.com/item?id=34233697 https://news.ycombinator.com/item?id=34233697
https://news.ycombinator.com/item?id=31981568 https://news.ycombinator.com/item?id=31981568
https://datastation.multiprocess.io/blog/2022-04-11-sql-parsers.html https://datastation.multiprocess.io/blog/2022-04-11-sql-pars...
https://tomassetti.me/parsing-sql/ https://tomassetti.me/parsing-sql/