Dialect-specific std lib

[rvalek]

Hi!
The Standard library paragraph in the Roadmap mentions a challenge with functionalities that look differently across most SQL dialects, like regex:

One challenge here is the variety of functionalities and syntax of target DBMSs; e.g. there’s no standard regex function.

A relatively straightforward way to solve this is by introducing dialect-specific standard library extensions, where dialect-specific expressions would be wrapped in a uniform prql interface. An example of this approach in Logica (another SQL-compiled language): https://github.com/EvgSkv/logica/tree/main/compiler/dialect_libraries

Is this what the core team has in mind, or you see a better approach?

My use-case is bridging the gaps among the different engines used by my team: Trino, Spark, Snowflake, so I'd be happy to contribute better cross-dialect support if you share your preferred approach to this. Let's talk if you're interested!

Thank you for your amazing work on PRQL!

[rvalek]

Spoke too soon! I see that this is already a part of the standard lib using modules:

prql/prqlc/prqlc/src/sql/std.sql.prql

Line 377 in aac8ae8

module snowflake {

[rvalek]

Love this!