tobilg/polyglot can be used to support SQL dialects?

[eitsupi]

https://github.com/tobilg/polyglot

[max-sixty]

interesting!!

do you know how feasible packaging would be?

[eitsupi]

I haven't seen anything about the contents yet.

[snth]

This is cool. I was aware of sqlglot, but there the issue was that it was Python.

[snth]

@eitsupi so you're suggesting that prql-compiler produces ANSI SQL and then polyglot could specialise to the target dialect?

[eitsupi]

In fact, I'm not sure how much it will be usable.
For example, something like DuckDB's exclude can be translated directly from PRQL, but I expect that it will become unsupportable once it goes through ANSI SQL.

[snth]

Good point. So I think Substrait is still the best option as compilation target and then specialized from there. Any idea if polyglot supports Substrait?

[snth]

My ANSI SQL comment was the wrong approach. I just skimmed over polyglot and I think there is actually a lot that could be done with it. I'll try to research it a bit more in depth.