R Observatory: Metrics for polyglotSQL version 0.1.0

Balamuta, James Joseph

doi:10.5281/zenodo.21843040

polyglotSQL

0.1.0

SQL Parsing, Analysis and Dialect Translation

0packages depend

81downloads / year

–test coverage

10/12checks pass

Overview

About

Maintained by Andre LeiteFirst published 2026-08-041 releasesCRAN page ↗GitHub ↗

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.

Install

R (CRAN)pak (dev)Fedora (COPR)

install.packages("polyglotSQL", repos = "https://cloud.r-project.org/")

Installs the current CRAN release. Prebuilt binaries on Windows and macOS.

if (!requireNamespace("pak", quietly = TRUE))
  install.packages("pak", repos = "https://cloud.r-project.org/")
pak::pak("StrategicProjects/polyglot-sql-r")

Development version from StrategicProjects/polyglot-sql-r. Installs pak first if it is not already available.

# enable the iucar/cran COPR if it is not already present, then install
ls /etc/yum.repos.d/*iucar*cran*.repo >/dev/null 2>&1 \
  || sudo dnf copr enable -y iucar/cran
sudo dnf install -y R-CRAN-polyglotSQL

RPMs from the iucar/cran COPR, rebuilt from CRAN.

For install.packages() integration in R, also: sudo dnf install R-CoprManager

Health

CRAN checks

2ERROR10OK

Failing flavors

ERROR r-oldrel-macos-x86_64
ERROR r-release-macos-x86_64

Slowest check: 44.5 min · r-release-windows-x86_64

Code health

Yes

Tests · ratio 0.61

not tracked

Coverage

100%

Documentation · exports

2

Dependencies · direct

Check history

ERROR2026-08-05
5 OK · 0 NOTE · 0 WARNING · 2 ERROR · 0 FAILURE

Documentation

READMEYes · 425 wordsVignettesYes · dynamicpkgdown siteNoNEWSYes · 67% structuredCode of conductNoContributing guideNo

Examples that run: 100%
Documented parameters: 92%
Return-value docs: 100%
References docs: 0%

Downloads

81

CRAN downloads in the past year

Rank #24,700 · ~0/day · ~7/mo

polyglotSQL Releases R versions

Daily download trend is not available in this view yet.

8130 days

8190 days

811 year

Compare downloads with other packages →

Repository

GitHub ↗ strategicprojects/polyglot-sql-r

1Stars

0Forks

3Open issues

0Open PRs

0Releases

11Commits

1Contributors

11 commits · Last activity 2026-07-21

Issues over time

2026-08-05 · 22026-08-06 · 3

Repository practices

Upstream repositoryBeta

4 development-tooling and community-health practices detected across 4 families in the upstream repository

Checks run against github.com/strategicprojects/polyglot-sql-r on 2026-08-09.

Continuous integration (1)

GitHub Actions

CRAN release process (1)

cran-comments.md

Docs source (1)

README.Rmd

Coverage (1)

Codecov

How this is detected·Detection ruleset v1 (2026-07-18)

Development tooling

AI-assisted toolingBeta

Uses AI-assisted development tooling (declared in repo)

Earliest detected marker: claude on 2026-07-19

claude

Most recent: claude on 2026-07-19

Evidence

claude: on 2026-07-19 · evidence B, D

How this is detected·Detection ruleset v2 (updated 2026-07-29)

Dependencies

Declared dependencies

5 external dependencies (excludes base and recommended)

Depends (1)

R >= 4.2

Imports (2)

cli jsonlite

LinkingTo (0)

none

Suggests (3)

knitr rmarkdown testthat

Enhances (0)

none

Dependency license breakdown →

Reverse dependencies

0direct

0indirect

Nothing depends on this yet.

Code & Tests

People & History

People (8)

Maintainer (1)

Andre Leite

Author, Maintainer

Authors (5)

Author, Maintainer

Author

Author

Author

Author

Copyright holders (3)

Toby Mao

Copyright holder

Tobias Müller

Copyright holder

The authors of the vendored Rust dependencies

Copyright holder

Package Timeline

1 release. R releases are shown for context.

0.1.0Latest
2026-08-04 · current release
R
R 4.6.0 released · 2026-04-24

Package metadata

First published: 2026-08-04
Total releases: 1 / 1 yrs
License: MIT + file LICENSE OSI
Minimum R: ≥ 4.2
Download size: not tracked yet
Installed size: not tracked yet
With dependencies: not tracked yet

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("polyglotSQL")

Format

Leite, A., Amorim, C., Bezerra, D., Mao, T., Müller, T., The authors of the vendored Rust dependencies, , Vasconcelos, H., & Wasiliew, M. (2026). polyglotSQL: SQL Parsing, Analysis and Dialect Translation (Version 0.1.0) [Computer software]. https://doi.org/10.32614/CRAN.package.polyglotSQL

This is what citation() produces when a package has no citation file of its own. If it prints something else, use that.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

Format

APA

Balamuta, J. J. (2026). R Observatory: Metrics for polyglotSQL version 0.1.0 [Data set]. HJJB, LLC. Data release v2026-08-11. https://doi.org/10.5281/zenodo.21843040

From data release v2026-08-11, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →