{ "_id": "6a1efdb5b401979e73419c36", "Package": "SQLFormatteR", "Title": "Format SQL Queries", "Version": "0.0.2.9000", "Authors@R": "c(\nperson(\"Morgan\", \"Durand\", , \"morgan@dataupsurge.com\", role = c(\"aut\", \"cre\", \"cph\")),\nperson(\"Authors of the dependent Rust crates\", role = \"aut\",\ncomment = \"see AUTHORS file\")\n)", "Description": "A convenient interface for formatting 'SQL' queries\ndirectly within 'R'. It acts as a wrapper around the\n'sql_format' Rust crate. The package allows you to format 'SQL'\ncode with customizable options, including indentation, case\nformatting, and more, ensuring your 'SQL' queries are clean,\nreadable, and consistent.", "License": "MIT + file LICENSE", "URL": "https://dataupsurge.github.io/SQLFormatteR/,\nhttps://github.com/dataupsurge/SQLFormatteR", "BugReports": "https://github.com/dataupsurge/SQLFormatteR/issues", "Config/rextendr/version": "0.3.1.9001", "Config/SQLFormatteR/MSRV": "1.78.0", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.2", "SystemRequirements": "Cargo (Rust's package manager), rustc >= 1.78.0", "Config/pak/sysreqs": "libclang-dev", "Repository": "https://dataupsurge.r-universe.dev", "Date/Publication": "2025-04-14 12:49:17 UTC", "RemoteUrl": "https://github.com/dataupsurge/sqlformatter", "RemoteRef": "HEAD", "RemoteSha": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "NeedsCompilation": "yes", "Packaged": { "Date": "2026-05-18 09:52:19 UTC", "User": "root" }, "Author": "Morgan Durand [aut, cre, cph],\nAuthors of the dependent Rust crates [aut] (see AUTHORS file)", "Maintainer": "Morgan Durand ", "MD5sum": "eab1256aa67d6ddac36678f57f486bb7", "_user": "dataupsurge", "_type": "src", "_file": "SQLFormatteR_0.0.2.9000.tar.gz", "_fileid": "c29ff6289ddab76ba9cdab03b0b2484125b4ad6c8018c57d6d845a67c372115e", "_filesize": 902819, "_sha256": "c29ff6289ddab76ba9cdab03b0b2484125b4ad6c8018c57d6d845a67c372115e", "_created": "2026-05-18T09:52:19.000Z", "_published": "2026-06-02T15:58:45.625Z", "_distro": "noble", "_jobs": [ { "job": 79114390663, "time": 137, "config": "linux-devel-arm64", "r": "4.7.0", "check": "OK", "artifact": "7054695751" }, { "job": 79114390668, "time": 148, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7054699188" }, { "job": 79114391129, "time": 134, "config": "linux-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7054694521" }, { "job": 79114391324, "time": 146, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7054698488" }, { "job": 79114391298, "time": 136, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7054689970" }, { "job": 79114391178, "time": 307, "config": "macos-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "7054744766" }, { "job": 79114390513, "time": 150, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7054692084" }, { "job": 79114390901, "time": 224, "config": "macos-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7054715309" }, { "job": 79114389683, "time": 203, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7054650205" }, { "job": 79114389839, "time": 156, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7363032258" }, { "job": 79114390509, "time": 137, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7054695832" }, { "job": 79114390729, "time": 159, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7054702601" }, { "job": 79114390941, "time": 121, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7054690314" } ], "_buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/dataupsurge/sqlformatter", "_commit": { "id": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "author": "mdurand ", "committer": "Morgan Durand ", "message": "chore: fix R-CMD-check badge in README\n", "time": 1744634957 }, "_maintainer": { "name": "Morgan Durand", "email": "morgan@dataupsurge.com", "login": "durandm", "description": "", "uuid": 23086020 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2", "role": "Depends" }, { "package": "assertthat", "role": "Imports" }, { "package": "covr", "version": ">= 3.6.4", "role": "Suggests" }, { "package": "docopt", "version": ">= 0.7.1", "role": "Suggests" }, { "package": "git2r", "version": ">= 0.35.0", "role": "Suggests" }, { "package": "jsonlite", "version": ">= 1.8.9", "role": "Suggests" }, { "package": "lintr", "version": ">= 3.1.2", "role": "Suggests" }, { "package": "optparse", "version": ">= 1.7.5", "role": "Suggests" }, { "package": "precommit", "version": ">= 0.4.3", "role": "Suggests" }, { "package": "rextendr", "version": ">= 0.3.1", "role": "Suggests" }, { "package": "roxygen2", "version": ">= 7.3.2", "role": "Suggests" }, { "package": "styler", "version": ">= 1.10.3", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "dataupsurge", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 8, "_contributors": [ { "user": "josiahparry", "count": 1, "uuid": 13534508 } ], "_userbio": { "uuid": 197060486, "type": "organization", "name": "dataupsurge" }, "_downloads": { "count": 196, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/SQLFormatteR" }, "_devurl": "https://github.com/dataupsurge/sqlformatter", "_pkgdown": "https://dataupsurge.github.io/SQLFormatteR/", "_searchresults": 3, "_cargo": true, "_topics": [ "rust", "cargo" ], "_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/SQLFormatteR.html", "manual.pdf" ], "_homeurl": "https://github.com/dataupsurge/sqlformatter", "_realowner": "dataupsurge", "_cranurl": true, "_releases": [ { "version": "0.0.1", "date": "2025-02-04" }, { "version": "0.0.2", "date": "2025-04-13" } ], "_exports": [ "sql_format" ], "_help": [ { "page": "sql_format", "title": "Format an SQL Query", "topics": [ "sql_format" ] } ], "_readme": "https://github.com/dataupsurge/sqlformatter/raw/HEAD/README.md", "_rundeps": [ "assertthat" ], "_score": 3.6020599913279625, "_indexed": true, "_nocasepkg": "sqlformatter", "_universes": [ "dataupsurge", "durandm" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.0.2.9000", "date": "2026-05-18T09:54:44.000Z", "distro": "noble", "arch": "aarch64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "2178f42a07ece9e02338ed788883d27cee38a6b08bf649cde280996536d9a6b3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.7.0", "os": "linux", "version": "0.0.2.9000", "date": "2026-05-18T09:54:52.000Z", "distro": "noble", "arch": "x86_64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "d647f6f653da7dd516854551c4bc408f98bf40d14be01f98dddd731e997ec54f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.6.0", "os": "linux", "version": "0.0.2.9000", "date": "2026-05-18T09:54:40.000Z", "distro": "noble", "arch": "aarch64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "9986822009680fd200ac7981e90fead7005f707a972235954c9d7c61ed884430", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.6.0", "os": "linux", "version": "0.0.2.9000", "date": "2026-05-18T09:54:50.000Z", "distro": "noble", "arch": "x86_64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "34fdf38e31df27a15474ff35773c4b2408a39c4bc63dbbaa78a7687b38a9cf6c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.5.3", "os": "mac", "version": "0.0.2.9000", "date": "2026-05-18T09:54:25.000Z", "arch": "aarch64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "ac0cb77d196a44e8e9fd51996d5bb2da1e228b17489d816e37cc0c822e3e2953", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.5.3", "os": "mac", "version": "0.0.2.9000", "date": "2026-05-18T09:56:38.000Z", "arch": "x86_64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "abcc2119455d27beb52af67105de0ee80c5244e56428cd23c282ae2617b612a5", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.6.0", "os": "mac", "version": "0.0.2.9000", "date": "2026-05-18T09:54:26.000Z", "arch": "aarch64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "5e2fc9e8ba13dbec4737cef86aa991cc6f524603369f81382c77df6bf5249669", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.6.0", "os": "mac", "version": "0.0.2.9000", "date": "2026-05-18T09:55:15.000Z", "arch": "x86_64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "9ccaf72413fd7b98f1dbbaefe44f56284ebe0abeb131644ee7987a27b83b9f10", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.7.0", "os": "win", "version": "0.0.2.9000", "date": "2026-05-18T09:53:51.000Z", "arch": "x86_64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "1c85017a7d7cb281b92e53d0e570c65286c2c9ba2db595a275ceb7f2f381d5d7", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.5.3", "os": "win", "version": "0.0.2.9000", "date": "2026-05-18T09:53:48.000Z", "arch": "x86_64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "90f55f3ec82974edc57d83daf2c0831ecf066c00c0152325faed206464b54473", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.6.0", "os": "win", "version": "0.0.2.9000", "date": "2026-05-18T09:53:44.000Z", "arch": "x86_64", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "68bf2ca509ac5e64f3429325fd1ecdda65bc3c2c67f1eb621777fc3b9c8ce22b", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" }, { "r": "4.6.0", "os": "wasm", "version": "0.0.2.9000", "date": "2026-06-02T15:58:06.000Z", "arch": "emscripten", "commit": "ad5bf1188d40fae0624cf25894fbabd9a7c708bd", "fileid": "3911517884d316ab7989abc5bd050bc1452eeb188b3142e645d9b26d705e4821", "status": "success", "buildurl": "https://github.com/r-universe/dataupsurge/actions/runs/26026074620" } ] }