{ "_id": "6a5db0df9baadeef8ab534bc", "Package": "sqlparseR", "Type": "Package", "Title": "Wrapper for 'Python' Module 'sqlparse': Parse, Split, and Format\n'SQL'", "Version": "0.1.0", "Authors@R": "person(\"Michael\", \"Simmler\", email = \"michael.simmler@agroscope.admin.ch\", role = c(\"aut\", \"cre\"))", "Description": "Wrapper for the non-validating 'SQL' parser 'Python'\nmodule 'sqlparse' .\nIt allows parsing, splitting, and formatting 'SQL' statements.", "License": "GPL-3", "Encoding": "UTF-8", "NeedsCompilation": "no", "Packaged": { "Date": "2026-07-20 05:19:34 UTC", "User": "root" }, "Author": "Michael Simmler [aut, cre]", "Maintainer": "Michael Simmler ", "Config/pak/sysreqs": "libpng-dev python3", "Repository": "https://agroscope-ch.r-universe.dev", "Date/Publication": "2023-11-24 16:03:58 UTC", "RemoteUrl": "https://github.com/agroscope-ch/sqlparser", "RemoteRef": "HEAD", "RemoteSha": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "_user": "agroscope-ch", "_type": "src", "_file": "sqlparseR_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/f4dcdc655aeae67c9e3fb9486fc5437211f4e7a5b7733fb1474bdb12f5c780bc", "_filesize": 102234, "_sha256": "f4dcdc655aeae67c9e3fb9486fc5437211f4e7a5b7733fb1474bdb12f5c780bc", "_expires": "2026-10-28T05:23:41.000Z", "_created": "2026-07-20T05:19:34.000Z", "_published": "2026-07-20T05:23:43.272Z", "_jobs": [ { "job": 88277484814, "time": 149, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8451606177" }, { "job": 88277484819, "time": 187, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8451615116" }, { "job": 88277484827, "time": 86, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8451596757" }, { "job": 88277484838, "time": 89, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8451618589" }, { "job": 88277119622, "time": 181, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8451567487" }, { "job": 88277484823, "time": 107, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8451595721" }, { "job": 88277484846, "time": 114, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8451597187" }, { "job": 88277484850, "time": 116, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8451598023" }, { "job": 88277484847, "time": 126, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8451600635" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/29718760812", "_status": "success", "_upstream": "https://github.com/agroscope-ch/sqlparser", "_commit": { "id": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "author": "AgroSimi <48689093+AgroSimi@users.noreply.github.com>", "committer": "GitHub ", "message": "Update README.md", "time": 1700841838 }, "_maintainer": { "name": "Michael Simmler", "email": "michael.simmler@agroscope.admin.ch", "login": "michaelsimmler", "description": "", "uuid": 48689093 }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "reticulate", "version": ">= 1.13", "role": "Imports" } ], "_owner": "agroscope-ch", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "michaelsimmler", "count": 4, "uuid": 48689093 } ], "_userbio": { "uuid": 95276560, "type": "organization", "name": "Agroscope", "followers": 25, "description": "Agroscope is the Swiss centre of excellence for agricultural research" }, "_downloads": { "count": 202, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlparseR" }, "_devurl": "https://github.com/agroscope-ch/sqlparser", "_searchresults": 4, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/sqlparseR.html", "manual.pdf" ], "_realowner": "michaelsimmler", "_cranurl": false, "_releases": [ { "version": "0.1.0", "date": "2019-09-20" } ], "_exports": [ "install_sqlparse_py", "sql_format", "sql_parse", "sql_split" ], "_help": [ { "page": "install_sqlparse_py", "title": "Install sqlparse Python package", "topics": [ "install_sqlparse_py" ] }, { "page": "sql_format", "title": "Format SQL Statements", "topics": [ "sql_format" ] }, { "page": "sql_parse", "title": "Parse SQL Statements", "topics": [ "sql_parse" ] }, { "page": "sql_split", "title": "Split SQL to Single Statements", "topics": [ "sql_split" ] } ], "_readme": "https://github.com/agroscope-ch/sqlparser/raw/HEAD/README.md", "_rundeps": [ "here", "jsonlite", "lattice", "Matrix", "png", "rappdirs", "Rcpp", "RcppTOML", "reticulate", "rlang", "rprojroot", "withr" ], "_score": 1.6989700043360187, "_indexed": false, "_nocasepkg": "sqlparser", "_universes": [ "agroscope-ch" ], "_indexurl": "https://michaelsimmler.r-universe.dev/sqlparseR", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-07-20T05:21:54.000Z", "distro": "resolute", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "https://r2.ropensci.org/88a87ef520328e862b2b986f03b4111037c859afc5fa6ec1bb5b3fe2f5b4544c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/29718760812" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-07-20T05:22:28.000Z", "distro": "resolute", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "https://r2.ropensci.org/4d48c64eafc3367610da1c56ad10a766b377ca78a44bf7cbbf7e8b558f7e6e0a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/29718760812" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-07-20T05:21:24.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "https://r2.ropensci.org/20c6f311b2aaf58d1df1ef39e951939acb7045c9061257a1835789d1af2344d8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/29718760812" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-07-20T05:22:53.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "https://r2.ropensci.org/6651f04b8e9ead4ebb254dbeacb468fb8956b94c0cd81dada9eeb1f2a82043b2", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/29718760812" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-07-20T05:21:39.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "https://r2.ropensci.org/58ade91b337147363f9d77664b841eaba9a0a1b96ab337e4c64c1b830cda99f7", "status": "success", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/29718760812" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-07-20T05:20:31.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "https://r2.ropensci.org/31fbab71cc76b991228faac9d5dc99b964e7e8af196b56cd0751ce81ac8b27f6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/29718760812" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-07-20T05:20:42.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "https://r2.ropensci.org/4e0e3c5e4dc347ad1cafc27eafdcf9881ab57f090c520e9550d310cfec28c7f1", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/29718760812" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-07-20T05:20:45.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "https://r2.ropensci.org/b98300d5b498af6906c821810543bb3a02f6367ffef2bfb5ad14ff9e1b428d72", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/29718760812" } ] }