Package: polyglotSQL 0.1.0

Andre Leite

polyglotSQL: SQL Parsing, Analysis and Dialect Translation

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.

Authors:Andre Leite [aut, cre], Marcos Wasiliew [aut], Hugo Vasconcelos [aut], Carlos Amorim [aut], Diogo Bezerra [aut], Tobias Müller [cph], Toby Mao [cph], The authors of the vendored Rust dependencies [cph]

polyglotSQL_0.1.0.tar.gz
polyglotSQL_0.1.0.zip(r-4.7-x86_64)polyglotSQL_0.1.0.zip(r-4.7-arm64)polyglotSQL_0.1.0.zip(r-4.6-x86_64)polyglotSQL_0.1.0.zip(r-4.6-arm64)polyglotSQL_0.1.0.zip(r-4.5-x86_64)
polyglotSQL_0.1.0.tgz(r-4.6-x86_64)polyglotSQL_0.1.0.tgz(r-4.6-arm64)polyglotSQL_0.1.0.tgz(r-4.5-x86_64)polyglotSQL_0.1.0.tgz(r-4.5-arm64)
polyglotSQL_0.1.0.tar.gz(r-4.7-arm64)polyglotSQL_0.1.0.tar.gz(r-4.7-x86_64)polyglotSQL_0.1.0.tar.gz(r-4.6-arm64)polyglotSQL_0.1.0.tar.gz(r-4.6-x86_64)
polyglotSQL_0.1.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
polyglotSQL/json (API)

# Install 'polyglotSQL' in R:
install.packages('polyglotSQL', repos = c('https://strategicprojects.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/strategicprojects/polyglot-sql-r/issues

Pkgdown/docs site:https://strategicprojects.github.io

On CRAN:

Conda:

rustcargo

4.60 score 1 stars 7 scripts 16 exports 2 dependencies

Last updated from:3f8bb85f8e. Checks:15 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-arm64OK1078
linux-devel-x86_64OK966
source / vignettesOK1748
linux-release-arm64OK1083
linux-release-x86_64OK975
macos-release-arm64OK2282
macos-release-x86_64OK2365
macos-oldrel-arm64OK2418
macos-oldrel-x86_64OK2238
windows-devel-arm64OK1699
windows-devel-x86_64OK1902
windows-release-arm64OK1761
windows-release-x86_64OK1892
windows-oldrel-x86_64OK1837
wasm-releaseOK1082

Exports:as_polyglot_schemapolyglot_versionsql_analyzesql_annotate_typessql_dialectssql_diffsql_formatsql_generatesql_lineagesql_openlineagesql_optimizesql_parsesql_source_tablessql_tokenizesql_transpilesql_validate

Dependencies:clijsonlite

Installation and troubleshooting
Requirements | Installing Rust | Installing the package | Offline / air-gapped builds | Build details you may care about | Troubleshooting | cargo: command not found / configure fails | rustc >= 1.88 required | Linker errors on macOS | Windows: cannot find -lpolyglotsql or wrong target | Updating the embedded engine (for developers) | Verifying an installation
Rendered frominstallation-and-troubleshooting.Rmdusingknitr::rmarkdown

Last update: 2026-07-20
Started: 2026-07-19

Getting started with polyglotSQL
Your first translation | Which dialects? | Formatting | Validating | Parsing and round-tripping | Errors are classed conditions | Where to next?
Rendered fromgetting-started.Rmdusingknitr::rmarkdown

Last update: 2026-07-19
Started: 2026-07-19

Migrating SQL between dialects
Typical rewrites | Migrating a batch of queries | Handling unsupported constructs | Verifying the migration structurally | What transpilation cannot do
Rendered fromdialect-migration.Rmdusingknitr::rmarkdown

Last update: 2026-07-19
Started: 2026-07-19

Parsing, validation and lineage
The AST | Tokens | Validation | Source tables | Column-level lineage | Structural analysis | OpenLineage export
Rendered fromparsing-validation-lineage.Rmdusingknitr::rmarkdown

Last update: 2026-07-19
Started: 2026-07-19