{ "_id": "6a1beac11d7bb097a0a1e7f1", "Package": "sqlfluffr", "Type": "Package", "Title": "Wrapper to the 'SQL' Linter and Formatter 'sqlfluff'", "Version": "0.1.0", "Authors@R": "c(\nperson(\n\"Brenden\", \"Smith\",\nemail = \"brendensmithmi@gmail.com\",\nrole = c(\"aut\", \"cre\", \"cph\")\n)\n)", "Description": "An R interface to the 'Python' 'sqlfluff' 'SQL' linter and\nformatter via the 'reticulate' package. Enables linting,\nfixing, and parsing of 'SQL' queries with support for multiple\ndialects. Includes special handling for 'glue' 'SQL' syntax\nwith curly-brace placeholders.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "Config/testthat/edition": "3", "RoxygenNote": "7.3.2", "URL": "https://github.com/brendensm/sqlfluffr", "BugReports": "https://github.com/brendensm/sqlfluffr/issues", "Config/pak/sysreqs": "libpng-dev python3", "Repository": "https://brendensm.r-universe.dev", "Date/Publication": "2026-03-02 17:03:32 UTC", "RemoteUrl": "https://github.com/brendensm/sqlfluffr", "RemoteRef": "HEAD", "RemoteSha": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-31 07:20:02 UTC", "User": "root" }, "Author": "Brenden Smith [aut, cre, cph]", "Maintainer": "Brenden Smith ", "MD5sum": "c651e4132a6d9ab40da0fa71afdeb47b", "_user": "brendensm", "_type": "src", "_file": "sqlfluffr_0.1.0.tar.gz", "_fileid": "00f4821f318ef706d1beab7600aa5de26cf22f0b1a2e694649e4482a8fff9599", "_filesize": 107819, "_sha256": "00f4821f318ef706d1beab7600aa5de26cf22f0b1a2e694649e4482a8fff9599", "_created": "2026-05-31T07:20:02.000Z", "_published": "2026-05-31T08:01:05.582Z", "_distro": "noble", "_jobs": [ { "job": 78708273280, "time": 117, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7314764617" }, { "job": 78708273290, "time": 108, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7314763697" }, { "job": 78708273276, "time": 108, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7315034902" }, { "job": 78708273278, "time": 79, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7315019735" }, { "job": 78708088798, "time": 201, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7314750964" }, { "job": 78708273270, "time": 87, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7314761215" }, { "job": 78708273283, "time": 75, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7314759922" }, { "job": 78708273291, "time": 83, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7314760774" }, { "job": 78708273289, "time": 78, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7314760342" } ], "_buildurl": "https://github.com/r-universe/brendensm/actions/runs/26706286801", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/brendensm/sqlfluffr", "_commit": { "id": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "author": "brendensm ", "committer": "brendensm ", "message": "add badge and CRAN install to readme\n", "time": 1772471012 }, "_maintainer": { "name": "Brenden Smith", "email": "brendensmithmi@gmail.com", "login": "brendensm", "description": "", "uuid": 97240544 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.0", "role": "Depends" }, { "package": "reticulate", "role": "Imports" }, { "package": "testthat", "version": ">= 3.2.0", "role": "Suggests" }, { "package": "glue", "role": "Suggests" }, { "package": "rstudioapi", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "brendensm", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2026-05", "n": 13 }, { "week": "2026-06", "n": 29 }, { "week": "2026-07", "n": 18 }, { "week": "2026-08", "n": 9 }, { "week": "2026-10", "n": 1 } ], "_tags": [], "_stars": 3, "_contributors": [ { "user": "brendensm", "count": 70, "uuid": 97240544 } ], "_userbio": { "uuid": 97240544, "type": "user", "name": "B" }, "_downloads": { "count": 465, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlfluffr" }, "_devurl": "https://github.com/brendensm/sqlfluffr", "_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/sqlfluffr.html", "manual.pdf" ], "_homeurl": "https://github.com/brendensm/sqlfluffr", "_realowner": "brendensm", "_cranurl": true, "_releases": [ { "version": "0.1.0", "date": "2026-02-25" } ], "_exports": [ "sqlf_config", "sqlf_config_edit", "sqlf_dialects", "sqlf_fix", "sqlf_install", "sqlf_lint", "sqlf_parse", "sqlf_rules" ], "_help": [ { "page": "sqlf_config", "title": "Write a project-level sqlfluff configuration file", "topics": [ "sqlf_config" ] }, { "page": "sqlf_config_edit", "title": "Open the sqlfluff configuration file for editing", "topics": [ "sqlf_config_edit" ] }, { "page": "sqlf_dialects", "title": "List available SQL dialects", "topics": [ "sqlf_dialects" ] }, { "page": "sqlf_fix", "title": "Fix a SQL query", "topics": [ "sqlf_fix" ] }, { "page": "sqlf_install", "title": "Install sqlfluff Python package", "topics": [ "sqlf_install" ] }, { "page": "sqlf_lint", "title": "Lint a SQL query", "topics": [ "sqlf_lint" ] }, { "page": "sqlf_parse", "title": "Parse a SQL query", "topics": [ "sqlf_parse" ] }, { "page": "sqlf_rules", "title": "List available linting rules", "topics": [ "sqlf_rules" ] } ], "_readme": "https://github.com/brendensm/sqlfluffr/raw/HEAD/README.md", "_rundeps": [ "here", "jsonlite", "lattice", "Matrix", "png", "rappdirs", "Rcpp", "RcppTOML", "reticulate", "rlang", "rprojroot", "withr" ], "_score": 3.8750612633917, "_indexed": true, "_nocasepkg": "sqlfluffr", "_universes": [ "brendensm" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.1.0", "date": "2026-05-31T07:22:04.000Z", "distro": "noble", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "38a3bd843cc0028d82c30007852e4163bdecbc487d252078ab9cdf1617561612", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/26706286801" }, { "r": "4.6.0", "os": "linux", "version": "0.1.0", "date": "2026-05-31T07:21:57.000Z", "distro": "noble", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "cd8154eaad7415f80c640ff2491a1ff5ae0ed3d48454959b931850653f177827", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/26706286801" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-05-31T08:00:36.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "df7922edb0adb6453ea3418f2e40d0a434a792adbffb19873ddaa8f53132c529", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/26706286801" }, { "r": "4.6.0", "os": "mac", "version": "0.1.0", "date": "2026-05-31T07:58:22.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "bf8a807d666192b98cfc8be25d56a4669df14f9d5df88adac84d253b232efbab", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/26706286801" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-05-31T07:21:46.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "6d5670f112ab0b732f30d4adcfc702be0dac6b0a8c624582e87ec5f6a3e441c8", "status": "success", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/26706286801" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-05-31T07:21:21.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "48043aa83f99f58b3fdaf0b66b6b9b9502042f20a5c32607337857fa2197de7f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/26706286801" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-05-31T07:21:22.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "6e4f0bc20480647124a2888109c3e82bcefd913e84d8cc5f2d501b085af6d1cb", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/26706286801" }, { "r": "4.6.0", "os": "win", "version": "0.1.0", "date": "2026-05-31T07:21:21.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "12fb56f6e8e27dec2836b121ce3696e3aceb732d90343d1bd7b57ffba5583421", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/26706286801" } ] }