{ "_id": "6acf29e8d9de2f3f33fc8822", "Package": "queryparser", "Type": "Package", "Title": "Translate 'SQL' Queries into 'R' Expressions", "Version": "0.3.2.9000", "Authors@R": "c(\nperson(\"Ian\", \"Cook\", email = \"ianmcook@gmail.com\", role = c(\"aut\", \"cre\")),\nperson(family = \"Cloudera\", role = c(\"cph\"))\n)", "Maintainer": "Ian Cook ", "Description": "Translate 'SQL' 'SELECT' statements into lists of 'R'\nexpressions.", "URL": "https://github.com/ianmcook/queryparser", "BugReports": "https://github.com/ianmcook/queryparser/issues", "NeedsCompilation": "no", "License": "Apache License 2.0", "Encoding": "UTF-8", "RoxygenNote": "7.0.2", "Collate": "'compat.R' 'agg_scalar.R' 'check_expressions.R'\n'column_references.R' 'common.R' 'extract_alias.R'\n'parse_clauses.R' 'parse_expression.R' 'parse_join.R'\n'translations.R' 'process_translations.R' 'parse_query.R'\n'parse_table_reference.R' 'replace.R' 'secure.R'\n'split_query.R' 'squish_sql.R' 'translate.R' 'unpipe.R'\n'unqualify.R' 'wrap_bangs.R'", "Repository": "https://ianmcook.r-universe.dev", "Date/Publication": "2023-01-09 21:38:23 UTC", "RemoteUrl": "https://github.com/ianmcook/queryparser", "RemoteRef": "HEAD", "RemoteSha": "ab74cc99d9df657607d28cc31104cda0618e130e", "Packaged": { "Date": "2026-10-14 07:02:31 UTC", "User": "root" }, "Author": "Ian Cook [aut, cre],\nCloudera [cph]", "_user": "ianmcook", "_type": "src", "_file": "queryparser_0.3.2.9000.tar.gz", "_fileid": "https://r2.ropensci.org/365d28bf717d7190afcda127c9e39528b3c327047b3021eb0ed9baf8074dc67a", "_filesize": 161730, "_sha256": "365d28bf717d7190afcda127c9e39528b3c327047b3021eb0ed9baf8074dc67a", "_expires": "2027-01-22T07:06:14.000Z", "_created": "2026-10-14T07:02:31.000Z", "_published": "2026-10-14T07:06:16.612Z", "_buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38525556202", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 115725886897, "time": 102, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11876330260" }, { "job": 115725886716, "time": 99, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11875577869" }, { "job": 115725887139, "time": 95, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "11876170484" }, { "job": 115725886860, "time": 113, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "11876035623" }, { "job": 115725108232, "time": 137, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11875811153" }, { "job": 115725886730, "time": 70, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11876255814" }, { "job": 115725886868, "time": 71, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11876185216" }, { "job": 115725886711, "time": 82, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "11876140324" }, { "job": 115725886787, "time": 82, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11876210758" } ], "_upstream": "https://github.com/ianmcook/queryparser", "_commit": { "id": "ab74cc99d9df657607d28cc31104cda0618e130e", "author": "Ian Cook ", "committer": "Ian Cook ", "message": "Minor changes to README and error messages\n", "time": 1673300303 }, "_maintainer": { "name": "Ian Cook", "email": "ianmcook@gmail.com", "login": "ianmcook", "bluesky": "@ian.columnar.tech", "linkedin": "in/ianmcook", "twitter": "@ianmcook", "description": "Accelerating data connectivity with Apache Arrow", "uuid": 280509 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "testthat", "version": ">= 2.1.0", "role": "Suggests" }, { "package": "covr", "version": ">= 3.2.0", "role": "Suggests" } ], "_owner": "ianmcook", "_selfowned": true, "_usedby": 1, "_updates": [], "_tags": [], "_topics": [ "database", "sql", "tidyverse" ], "_stars": 53, "_contributors": [ { "user": "ianmcook", "count": 29, "uuid": 280509 }, { "user": "stevenhibble", "count": 20, "uuid": 22333253 } ], "_userbio": { "uuid": 280509, "type": "user", "name": "Ian Cook", "followers": 177, "description": "Accelerating data connectivity with Apache Arrow" }, "_downloads": { "count": 325, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/queryparser" }, "_devurl": "https://github.com/ianmcook/queryparser", "_searchresults": 9, "_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/queryparser.html", "extra/readme.html", "extra/readme.md" ], "_homeurl": "https://github.com/ianmcook/queryparser", "_realowner": "ianmcook", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2019-09-03" }, { "version": "0.1.1", "date": "2019-09-05" }, { "version": "0.2.0", "date": "2020-01-16" }, { "version": "0.3.0", "date": "2020-05-10" }, { "version": "0.3.1", "date": "2021-01-17" }, { "version": "0.3.2", "date": "2023-01-14" } ], "_exports": [ "column_references", "extract_alias", "parse_expression", "parse_query", "split_query", "squish_sql", "unqualify_query" ], "_help": [ { "page": "column_references", "title": "Return the column references in a parsed SQL query", "topics": [ "column_references" ] }, { "page": "extract_alias", "title": "Extract the column alias from a SQL expression", "topics": [ "extract_alias" ] }, { "page": "parse_expression", "title": "Parse a SQL expression", "topics": [ "parse_expression" ] }, { "page": "parse_query", "title": "Parse a SQL query", "topics": [ "parse_query" ] }, { "page": "split_query", "title": "Split a SQL query", "topics": [ "split_query" ] }, { "page": "squish_sql", "title": "Squish a SQL query or SQL expression", "topics": [ "squish_sql" ] }, { "page": "unqualify_query", "title": "Remove prefixes from column references in a parsed SQL query", "topics": [ "unqualify_query" ] } ], "_pkglogo": "https://github.com/ianmcook/queryparser/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/ianmcook/queryparser/raw/HEAD/README.md", "_rundeps": [], "_score": 4.9003671286564705, "_indexed": true, "_nocasepkg": "queryparser", "_universes": [ "ianmcook" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.2.9000", "date": "2026-10-14T07:04:15.000Z", "distro": "resolute", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "https://r2.ropensci.org/93a3925164ee0055cb6e68b6a4fa1aa5984eada5651a330c80ba421897c09a81", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38525556202" }, { "r": "4.6.1", "os": "linux", "version": "0.3.2.9000", "date": "2026-10-14T07:04:13.000Z", "distro": "resolute", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "https://r2.ropensci.org/69bdb7a0f6b60c1c64396e7fa1a43063130b4af8a04b32a8da7a47cb05c68745", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38525556202" }, { "r": "4.5.3", "os": "mac", "version": "0.3.2.9000", "date": "2026-10-14T07:05:19.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "https://r2.ropensci.org/d8a92d292603836e56b5c4895f3ef8aec3d36e0fc4c5ecd7bd8ab75d3fb5fc15", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38525556202" }, { "r": "4.6.1", "os": "mac", "version": "0.3.2.9000", "date": "2026-10-14T07:05:32.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "https://r2.ropensci.org/57fbeb97bcfe5124505df3df096e19c745db2b4eeccb3989144fe926c6ab053b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38525556202" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.2.9000", "date": "2026-10-14T07:04:03.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "https://r2.ropensci.org/36039a6623b9360aa02fe452cfe3a21f194f5d79119f6b23fc5643abdcbc929e", "status": "success", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38525556202" }, { "r": "4.7.0", "os": "win", "version": "0.3.2.9000", "date": "2026-10-14T07:03:34.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "https://r2.ropensci.org/bbae1c932d331d904668d9fd355789dc9ba95736a939a4cf7ec4a170ff51cecd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38525556202" }, { "r": "4.5.3", "os": "win", "version": "0.3.2.9000", "date": "2026-10-14T07:03:51.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "https://r2.ropensci.org/25f8da84c2051d4c57cf658cc177f30d3d85191220c02615a80a9b97c3649479", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38525556202" }, { "r": "4.6.1", "os": "win", "version": "0.3.2.9000", "date": "2026-10-14T07:03:43.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "https://r2.ropensci.org/97c1557d6056cdbabcb14c6dcc40651c39ae1c6df9f034589320d8830979871e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/38525556202" } ] }