Parse, tokenize, validate, format, analyze and translate SQL between more than 30 dialects ('PostgreSQL', 'MySQL', 'BigQuery', 'Snowflake', 'DuckDB', 'T-SQL', and others) using the 'polyglot-sql' Rust crate <https://github.com/tobilg/polyglot>, a Rust port of the 'SQLGlot' 'Python' library. All processing happens locally in the R session; no database connection, 'Python' runtime or external service is required. Includes column-level lineage, structural query analysis, query optimization, 'AST' diffing and 'OpenLineage' facet generation.
Package details |
|
|---|---|
| Author | Andre Leite [aut, cre] (ORCID: <https://orcid.org/0000-0002-4718-9766>), Marcos Wasiliew [aut], Hugo Vasconcelos [aut] (ORCID: <https://orcid.org/0000-0001-6249-0920>), Carlos Amorim [aut] (ORCID: <https://orcid.org/0000-0001-6315-8305>), Diogo Bezerra [aut] (ORCID: <https://orcid.org/0000-0002-1216-8674>), Tobias Müller [cph] (Author of the bundled 'polyglot-sql' Rust crate (Polyglot project)), Toby Mao [cph] (Author of SQLGlot, from which Polyglot is derived), The authors of the vendored Rust dependencies [cph] (see inst/COPYRIGHTS) |
| Maintainer | Andre Leite <leite@castlab.org> |
| License | MIT + file LICENSE |
| Version | 0.1.1 |
| URL | https://github.com/StrategicProjects/polyglot-sql-r https://strategicprojects.github.io/polyglot-sql-r/ |
| Package repository | View on CRAN |
| Installation |
Install the latest version of this package by entering the following in R:
|
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.