{ "_id": "6ac85991de46216d5edd4630", "Package": "polyglotSQL", "Title": "SQL Parsing, Analysis and Dialect Translation", "Version": "0.1.3", "Authors@R": "c(\nperson(\"André\", \"Leite\", email = \"leite@castlab.org\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-4718-9766\")),\nperson(\"Marcos\", \"Wasiliew\", email = \"marcos.wasiliew@gmail.com\", role = \"aut\",\ncomment = c(ORCID = \"0009-0004-4694-3159\")),\nperson(\"Hugo\", \"Vasconcelos\", email = \"hugo.vasconcelos@ufpe.br\", role = \"aut\",\ncomment = c(ORCID = \"0000-0001-6249-0920\")),\nperson(\"Carlos\", \"Amorim\", email = \"carlos.agaf@ufpe.br\", role = \"aut\",\ncomment = c(ORCID = \"0000-0001-6315-8305\")),\nperson(\"Diogo\", \"Bezerra\", email = \"diogo.bezerra@ufpe.br\", role = \"aut\",\ncomment = c(ORCID = \"0000-0002-1216-8674\")),\nperson(\"Júlia\", \"Nascimento Barreto\", email = \"juliabarreto@gd.seplag.pe.gov.br\", role = \"aut\",\ncomment = c(ORCID = \"0009-0004-2851-7770\")),\nperson(\"Tobias\", \"Müller\", , \"github@tobilg.com\", role = \"cph\",\ncomment = \"Author of the bundled 'polyglot-sql' Rust crate (Polyglot project)\"),\nperson(\"Toby\", \"Mao\", role = \"cph\",\ncomment = \"Author of SQLGlot, from which Polyglot is derived\"),\nperson(, \"The authors of the vendored Rust dependencies\", role = \"cph\",\ncomment = \"see inst/COPYRIGHTS\")\n)", "Description": "Parse, tokenize, validate, format, analyze and translate\nSQL between more than 30 dialects ('PostgreSQL', 'MySQL',\n'BigQuery', 'Snowflake', 'DuckDB', 'T-SQL', and others) using\nthe 'polyglot-sql' Rust crate\n, a Rust port of the\n'SQLGlot' 'Python' library. All processing happens locally in\nthe R session; no database connection, 'Python' runtime or\nexternal service is required. Includes column-level lineage,\nstructural query analysis, query optimization, 'AST' diffing\nand 'OpenLineage' facet generation.", "License": "MIT + file LICENSE", "URL": "https://github.com/StrategicProjects/polyglot-sql-r,\nhttps://strategicprojects.github.io/polyglot-sql-r/", "BugReports": "https://github.com/StrategicProjects/polyglot-sql-r/issues", "VignetteBuilder": "knitr", "Config/polyglotSQL/upstream": "0.13.2", "Config/rextendr/version": "0.5.0", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Language": "en-US", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "8.0.0", "SystemRequirements": "Cargo (Rust's package manager), rustc >= 1.88.0, xz", "Config/pak/sysreqs": "xz-utils libclang-dev", "Repository": "https://strategicprojects.r-universe.dev", "Date/Publication": "2026-10-09 01:11:17 UTC", "RemoteUrl": "https://github.com/strategicprojects/polyglot-sql-r", "RemoteRef": "HEAD", "RemoteSha": "6f711d011fe98822c40223a8b84e451e5375d756", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-10-09 02:32:49 UTC", "User": "root" }, "Author": "André Leite [aut, cre] (ORCID: ),\nMarcos Wasiliew [aut] (ORCID: ),\nHugo Vasconcelos [aut] (ORCID: ),\nCarlos Amorim [aut] (ORCID: ),\nDiogo Bezerra [aut] (ORCID: ),\nJúlia Nascimento Barreto [aut] (ORCID:\n),\nTobias Müller [cph] (Author of the bundled 'polyglot-sql' Rust crate\n(Polyglot project)),\nToby Mao [cph] (Author of SQLGlot, from which Polyglot is derived),\nThe authors of the vendored Rust dependencies [cph] (see\ninst/COPYRIGHTS)", "Maintainer": "André Leite ", "_user": "strategicprojects", "_type": "src", "_file": "polyglotSQL_0.1.3.tar.gz", "_fileid": "https://r2.ropensci.org/4a92fbeaf1e4bc75733531e09b88da2ff2fb2d88e94ac5719de84d6521555637", "_filesize": 5692478, "_sha256": "4a92fbeaf1e4bc75733531e09b88da2ff2fb2d88e94ac5719de84d6521555637", "_expires": "2027-01-17T03:03:43.000Z", "_created": "2026-10-09T02:32:49.000Z", "_published": "2026-10-09T03:03:45.778Z", "_buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 113643489718, "time": 765, "config": "linux-devel-arm64", "r": "4.7.0", "check": "ERROR", "artifact": "11592781605" }, { "job": 113643489658, "time": 722, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "ERROR", "artifact": "11592721805" }, { "job": 113643489628, "time": 727, "config": "linux-release-arm64", "r": "4.6.1", "check": "ERROR", "artifact": "11593010621" }, { "job": 113643489662, "time": 762, "config": "linux-release-x86_64", "r": "4.6.1", "check": "ERROR", "artifact": "11592870667" }, { "job": 113643489619, "time": 686, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11592487502" }, { "job": 113643489608, "time": 423, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11592118178" }, { "job": 113643489596, "time": 1373, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11592424273" }, { "job": 113643489643, "time": 546, "config": "macos-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11592800572" }, { "job": 113639295454, "time": 1000, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11592570396" }, { "job": 113643489571, "time": 510, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11592611650" }, { "job": 113643489701, "time": 1143, "config": "windows-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "11592049660" }, { "job": 113643489651, "time": 959, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11592916487" }, { "job": 113643489672, "time": 1033, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11592558139" }, { "job": 113643489707, "time": 1218, "config": "windows-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11592966140" }, { "job": 113643489664, "time": 1323, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11592319737" } ], "_upstream": "https://github.com/strategicprojects/polyglot-sql-r", "_commit": { "id": "6f711d011fe98822c40223a8b84e451e5375d756", "author": "André Leite ", "committer": "Andre Leite Wanderley ", "message": "Address review: red zone for the unoptimized engine, test skip, docs\n\nThe macOS x86_64 CRAN override also sets debug-assertions=true for the\npolyglot-sql crate (overflow-checks stay off): the crate sizes the stack\nred zone of its recursive parser/generator by cfg!(debug_assertions),\n4 MB for unoptimized frames against 1 MB otherwise, so without it a\nrelaxed complexity guard could overflow the stack only on that build.\nVerified: the three --config flags build in 114 s on stable cargo.\n\nThe abort() test now skips unless the loaded DLL is an installed library\n(/libs/): pkgload::load_all() loads a temporary copy, so the previous\npath test never matched. README.md re-rendered against 0.13.2 (36\ndialects, error positions). NEWS states the actual condition for the\nunoptimized build (NOT_CRAN unset on macOS x86_64); cran-comments drops\nthe unfilled macbuilder entry and reports the measured 53.9 Mb.\n\nCo-Authored-By: Claude Fable 5.1 \n", "time": 1791508277 }, "_maintainer": { "name": "André Leite", "email": "leite@castlab.org", "orcid": "0000-0002-4718-9766" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2", "role": "Depends" }, { "package": "cli", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "strategicprojects", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-29", "n": 3 }, { "week": "2026-30", "n": 8 }, { "week": "2026-38", "n": 1 }, { "week": "2026-39", "n": 1 }, { "week": "2026-40", "n": 10 }, { "week": "2026-41", "n": 3 } ], "_tags": [ { "name": "v0.1.1", "date": "2026-09-21" }, { "name": "v0.1.2", "date": "2026-10-08" } ], "_stars": 2, "_contributors": [ { "user": "milkway", "count": 26, "uuid": 7375849 } ], "_userbio": { "uuid": 127886513, "type": "organization", "name": "Projetos Estratégicos", "followers": 14, "description": "Repositório de código da Assessoria Especial de Projetos Estratégicos." }, "_downloads": { "count": 323, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/polyglotSQL" }, "_devurl": "https://github.com/strategicprojects/polyglot-sql-r", "_pkgdown": "https://strategicprojects.github.io/polyglot-sql-r/", "_searchresults": 7, "_cargo": true, "_topics": [ "rust", "cargo" ], "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/polyglotSQL.html", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/strategicprojects/polyglot-sql-r", "_realowner": "strategicprojects", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2026-08-04" }, { "version": "0.1.1", "date": "2026-09-27" }, { "version": "0.1.2", "date": "2026-10-08" } ], "_exports": [ "as_polyglot_schema", "polyglot_version", "sql_analyze", "sql_annotate_types", "sql_dialects", "sql_diff", "sql_format", "sql_generate", "sql_lineage", "sql_openlineage", "sql_optimize", "sql_parse", "sql_source_tables", "sql_tokenize", "sql_transpile", "sql_validate" ], "_help": [ { "page": "as_polyglot_schema", "title": "Specify a table schema for schema-aware operations", "topics": [ "as_polyglot_schema" ] }, { "page": "polyglot_version", "title": "Versions of polyglotSQL and its embedded Rust engine", "topics": [ "polyglot_version" ] }, { "page": "sql_analyze", "title": "Structural query analysis", "topics": [ "sql_analyze" ] }, { "page": "sql_annotate_types", "title": "Annotate a query with inferred data types", "topics": [ "sql_annotate_types" ] }, { "page": "sql_dialects", "title": "List supported SQL dialects", "topics": [ "sql_dialects" ] }, { "page": "sql_diff", "title": "Structural diff between two SQL statements", "topics": [ "sql_diff" ] }, { "page": "sql_format", "title": "Format (pretty-print) SQL", "topics": [ "sql_format" ] }, { "page": "sql_generate", "title": "Generate SQL from a parsed AST", "topics": [ "sql_generate" ] }, { "page": "sql_lineage", "title": "Column-level lineage", "topics": [ "sql_lineage" ] }, { "page": "sql_openlineage", "title": "OpenLineage column-lineage facet", "topics": [ "sql_openlineage" ] }, { "page": "sql_optimize", "title": "Optimize SQL", "topics": [ "sql_optimize" ] }, { "page": "sql_parse", "title": "Parse SQL into an abstract syntax tree", "topics": [ "sql_parse" ] }, { "page": "sql_source_tables", "title": "List source tables referenced by SQL", "topics": [ "sql_source_tables" ] }, { "page": "sql_tokenize", "title": "Tokenize SQL", "topics": [ "sql_tokenize" ] }, { "page": "sql_transpile", "title": "Translate SQL between dialects", "topics": [ "sql_transpile" ] }, { "page": "sql_validate", "title": "Validate SQL", "topics": [ "sql_validate" ] } ], "_pkglogo": "https://github.com/strategicprojects/polyglot-sql-r/raw/HEAD/man/figures/logo.svg", "_readme": "https://github.com/strategicprojects/polyglot-sql-r/raw/HEAD/README.md", "_rundeps": [ "cli", "jsonlite" ], "_vignettes": [ { "source": "getting-started.Rmd", "filename": "getting-started.html", "title": "Getting started with polyglotSQL", "engine": "knitr::rmarkdown", "headings": [ "Your first translation", "Which dialects?", "Formatting", "Validating", "Parsing and round-tripping", "Errors are classed conditions", "Where to next?" ], "created": "2026-07-19 22:04:46", "modified": "2026-07-19 22:04:46", "commits": 1 }, { "source": "installation-and-troubleshooting.Rmd", "filename": "installation-and-troubleshooting.html", "title": "Installation and troubleshooting", "engine": "knitr::rmarkdown", "headings": [ "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" ], "created": "2026-07-19 22:04:46", "modified": "2026-10-09 01:11:17", "commits": 4 }, { "source": "dialect-migration.Rmd", "filename": "dialect-migration.html", "title": "Migrating SQL between dialects", "engine": "knitr::rmarkdown", "headings": [ "Typical rewrites", "Migrating a batch of queries", "Handling unsupported constructs", "Verifying the migration structurally", "What transpilation cannot do" ], "created": "2026-07-19 22:04:46", "modified": "2026-07-19 22:04:46", "commits": 1 }, { "source": "parsing-validation-lineage.Rmd", "filename": "parsing-validation-lineage.html", "title": "Parsing, validation and lineage", "engine": "knitr::rmarkdown", "headings": [ "The AST", "Tokens", "Validation", "Source tables", "Column-level lineage", "Structural analysis", "OpenLineage export" ], "created": "2026-07-19 22:04:46", "modified": "2026-07-19 22:04:46", "commits": 1 } ], "_score": 5.380211241711606, "_indexed": true, "_nocasepkg": "polyglotsql", "_universes": [ "strategicprojects" ], "_previous": "0.1.2", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.3", "date": "2026-10-09T02:41:42.000Z", "distro": "resolute", "arch": "aarch64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/57dcebcae2ee74e70fb616da068e8d39d967a26cd655060a58aa3e56e35a872a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.7.0", "os": "linux", "version": "0.1.3", "date": "2026-10-09T02:42:01.000Z", "distro": "resolute", "arch": "x86_64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/40617dce3fb60a935af4862643e99388a8d26f258d2504d32595a93604a56a6a", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.6.1", "os": "linux", "version": "0.1.3", "date": "2026-10-09T02:41:39.000Z", "distro": "resolute", "arch": "aarch64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/68d30afafee2a8748b0ceffe0e873d2b0f86482f0302f0fab1604a91221074ad", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.6.1", "os": "linux", "version": "0.1.3", "date": "2026-10-09T02:42:10.000Z", "distro": "resolute", "arch": "x86_64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/db1e42b6a2b6e00fc67623ba882426f2b1b4208e75de85eef8bf478345d16c75", "status": "failure", "check": "ERROR", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.5.3", "os": "mac", "version": "0.1.3", "date": "2026-10-09T02:41:43.000Z", "arch": "aarch64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/68845762a6162aaa15a3522115046dd9ac28f0dff93b3180315a6b1490460d61", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.5.3", "os": "mac", "version": "0.1.3", "date": "2026-10-09T02:42:22.000Z", "arch": "x86_64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/9001db72f2c0dec01cdf8561de05bc4cf72f29663d0f52f16206756c3879b2b3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.6.1", "os": "mac", "version": "0.1.3", "date": "2026-10-09T02:41:56.000Z", "arch": "aarch64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/f5aa3f46ec68dda116da8240acd4c923527e8ebc3de585c8b0f02d0a308b4007", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.6.1", "os": "mac", "version": "0.1.3", "date": "2026-10-09T02:43:12.000Z", "arch": "x86_64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/6bad76f5b81f63ea13c0c638d1356962e7c4541b2461dd1696b009e85548cef8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.3", "date": "2026-10-09T02:41:38.000Z", "arch": "emscripten", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/e216642e3ffd1a3160a053ce89783be7ffe79549fa3b8698feebb4a8aa08f9de", "status": "success", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.7.0", "os": "win", "version": "0.1.3", "date": "2026-10-09T02:42:44.000Z", "arch": "aarch64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/1c2d134453cc619928bbbf2f7a4ac47db8c41224d11157bb4069bf6e548a1af2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.7.0", "os": "win", "version": "0.1.3", "date": "2026-10-09T02:40:38.000Z", "arch": "x86_64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/3c21784e2d80ea66c2f2d8cb6bd418d3cfffd9781709e6dfe17d1d6964912363", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.5.3", "os": "win", "version": "0.1.3", "date": "2026-10-09T02:40:56.000Z", "arch": "x86_64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/8c8aad81afb26f6fbaa2c24d0e3018ba81a2f3d970fdb48a071df9d1fcf1de32", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.6.1", "os": "win", "version": "0.1.3", "date": "2026-10-09T02:44:01.000Z", "arch": "aarch64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/e4a8307a660847ebfcad421879917678d413b7415f5b0c9f1a3e958b5b69c87b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" }, { "r": "4.6.1", "os": "win", "version": "0.1.3", "date": "2026-10-09T02:40:55.000Z", "arch": "x86_64", "commit": "6f711d011fe98822c40223a8b84e451e5375d756", "fileid": "https://r2.ropensci.org/b11e055b5adc6489a3f8fe687d30c79452980d63661418a06c1cae4841ac9e6f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/strategicprojects/actions/runs/37874300331" } ] }