{ "_id": "6a156be4acfb0bcc41d63b18", "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-05-26 09:42:41 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", "MD5sum": "2e050672d0eeb9dfa6bd0c4c8b8e1805", "_user": "agroscope-ch", "_type": "src", "_file": "sqlparseR_0.1.0.tar.gz", "_fileid": "78ee066025f331150573d4868d42459b125fb7705b19b2bef36b43b0faf652ee", "_filesize": 102147, "_sha256": "78ee066025f331150573d4868d42459b125fb7705b19b2bef36b43b0faf652ee", "_created": "2026-05-26T09:42:41.000Z", "_published": "2026-05-26T09:46:12.076Z", "_distro": "noble", "_jobs": [ { "job": 77848148347, "time": 136, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7213851854" }, { "job": 77848148406, "time": 127, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7213848757" }, { "job": 77848148356, "time": 84, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7213834422" }, { "job": 77848148389, "time": 97, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7213838426" }, { "job": 77847708931, "time": 159, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7213805779" }, { "job": 77848148560, "time": 105, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7213840965" }, { "job": 77848148333, "time": 176, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7213865431" }, { "job": 77848148398, "time": 142, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7213854306" }, { "job": 77848148379, "time": 137, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7213852467" } ], "_buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/26444627830", "_status": "success", "_host": "GitHub-Actions", "_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 }, "_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", "description": "Agroscope is the Swiss centre of excellence for agricultural research" }, "_downloads": { "count": 159, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlparseR" }, "_devurl": "https://github.com/agroscope-ch/sqlparser", "_searchresults": 2, "_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/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-05-26T09:44:37.000Z", "distro": "noble", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "51eaab52542587b1950200a1e4e4fa71be264fcf24eea4e232cb9c902377a8e5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/26444627830" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-05-26T09:44:32.000Z", "distro": "noble", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "507b58586e03a83cde5e25ae27f37a98f5f05ad767306f90b3a5550681a43ff7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/26444627830" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-05-26T09:44:00.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "f651f825a968a39abf9a1f757fe3032c8c982157e9e9ae896415aa2d9333e606", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/26444627830" }, { "r": "4.6.0", "os": "mac", "version": "0.1.0", "date": "2026-05-26T09:44:04.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "0b473c011b0188c7000f51af8dd91da4ac96a93aeae8460446090198269a201b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/26444627830" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-05-26T09:44:39.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "a918f5a74b1cf2db9f7d6b9bcbf58012045c33a2267af9860fafcb48078aadb3", "status": "success", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/26444627830" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-05-26T09:44:09.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "632c26715bea76d9c18f9b661c7db99397a7ecb7d155ac9340b9099481fc3a98", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/26444627830" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-05-26T09:43:54.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "d91b4530ddcccf31c5c5e41d155b7fca8272fab8de6cb5dc45ba1cd32241b087", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/26444627830" }, { "r": "4.6.0", "os": "win", "version": "0.1.0", "date": "2026-05-26T09:43:41.000Z", "commit": "a52adfaf156995dee3267a0bde1cd2b4be8a0884", "fileid": "cc370c597176251bad8306ff52ed96cc0024342ad0d65686f16c0fe863844d97", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/agroscope-ch/actions/runs/26444627830" } ] }