{ "_id": "6a1f0d90b401979e7341d0ef", "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-05-17 09:08:34 UTC", "User": "root" }, "Author": "Ian Cook [aut, cre],\nCloudera [cph]", "MD5sum": "801f18f033114b77000db491ddb93cc6", "_user": "ianmcook", "_type": "src", "_file": "queryparser_0.3.2.9000.tar.gz", "_fileid": "c96c7384d4e9894a1e08dfed8cef213a553f881208a1137fef27a5c4dd4012c0", "_filesize": 162508, "_sha256": "c96c7384d4e9894a1e08dfed8cef213a553f881208a1137fef27a5c4dd4012c0", "_created": "2026-05-17T09:08:34.000Z", "_published": "2026-06-02T17:06:24.516Z", "_distro": "noble", "_jobs": [ { "job": 79127877839, "time": 114, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7041101836" }, { "job": 79127877795, "time": 116, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7041102009" }, { "job": 79127877935, "time": 90, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7041099142" }, { "job": 79127877307, "time": 117, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7041102131" }, { "job": 79127877467, "time": 155, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7041088648" }, { "job": 79127876880, "time": 94, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7364613240" }, { "job": 79127878409, "time": 87, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7041098735" }, { "job": 79127877936, "time": 73, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7041097237" }, { "job": 79127878115, "time": 86, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7041098663" } ], "_buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25986648630", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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", "description": "Accelerating data connectivity with Apache Arrow" }, "_downloads": { "count": 290, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/queryparser" }, "_devurl": "https://github.com/ianmcook/queryparser", "_searchresults": 11, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/queryparser.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_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.941759813814695, "_indexed": true, "_nocasepkg": "queryparser", "_universes": [ "ianmcook" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.3.2.9000", "date": "2026-05-17T09:10:29.000Z", "distro": "noble", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "78f1441fde64b0d7e39bab5848592146639ee5567b4adab01efc58c2a08659b3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25986648630" }, { "r": "4.6.0", "os": "linux", "version": "0.3.2.9000", "date": "2026-05-17T09:10:30.000Z", "distro": "noble", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "4f5e0291804e190fb4485778efbc50c7b73f2ffdaf2ee87c95638a11518e9879", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25986648630" }, { "r": "4.5.3", "os": "mac", "version": "0.3.2.9000", "date": "2026-05-17T09:10:09.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "84e76c62bf08076b32470df33a94b33a56bfd534e788a9302ed9b4d8fe3c9a31", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25986648630" }, { "r": "4.6.0", "os": "mac", "version": "0.3.2.9000", "date": "2026-05-17T09:10:31.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "313283a5b0b80fd894c456e127698a8c168998a48fec854faa434121dc4101fc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25986648630" }, { "r": "4.7.0", "os": "win", "version": "0.3.2.9000", "date": "2026-05-17T09:09:52.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "72c3564df912d036eb209b114d26f1cedfde700a19d91254bd0a763a7e3191b1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25986648630" }, { "r": "4.5.3", "os": "win", "version": "0.3.2.9000", "date": "2026-05-17T09:09:38.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "304c52cdb50f8351705ea6707b6b31ac7811195c927a47ac895319b8c89090fb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25986648630" }, { "r": "4.6.0", "os": "win", "version": "0.3.2.9000", "date": "2026-05-17T09:09:51.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "a77d8aa57f03c13ab2cab325721305e4a4a07f1d77eed121d1e4ad7fc4f82198", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25986648630" }, { "r": "4.6.0", "os": "wasm", "version": "0.3.2.9000", "date": "2026-06-02T17:06:04.000Z", "commit": "ab74cc99d9df657607d28cc31104cda0618e130e", "fileid": "18e379df94e72f1465f213728143293263dac4cc2c194500fb36f30a2c7ce709", "status": "success", "buildurl": "https://github.com/r-universe/ianmcook/actions/runs/25986648630" } ] }