{ "_id": "6a497f836d67900babdf7827", "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-07-04 21:45:02 UTC", "User": "root" }, "Author": "Brenden Smith [aut, cre, cph]", "Maintainer": "Brenden Smith ", "_user": "brendensm", "_type": "src", "_file": "sqlfluffr_0.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/ffa0ce635ea44ae948b66b5739fbfa45cafd3d4861060a28ede4ec49c2f19828", "_filesize": 109369, "_sha256": "ffa0ce635ea44ae948b66b5739fbfa45cafd3d4861060a28ede4ec49c2f19828", "_expires": "2026-10-12T21:47:46.000Z", "_created": "2026-07-04T21:45:02.000Z", "_published": "2026-07-04T21:47:47.547Z", "_jobs": [ { "job": 85169489236, "time": 130, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "8085708109" }, { "job": 85169489239, "time": 130, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "8085708152" }, { "job": 85169489252, "time": 133, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "8085705237" }, { "job": 85169489250, "time": 120, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "8085704450" }, { "job": 85169294004, "time": 196, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "8085692438" }, { "job": 85169489235, "time": 134, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "8085708518" }, { "job": 85169489262, "time": 67, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "8085700870" }, { "job": 85169489257, "time": 66, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "8085700581" }, { "job": 85169489242, "time": 71, "config": "windows-release", "r": "4.6.1", "check": "OK", "artifact": "8085701236" } ], "_host": "GitHub-Actions", "_buildurl": "https://github.com/r-universe/brendensm/actions/runs/28720525041", "_status": "success", "_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 }, "_distro": "resolute", "_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", "followers": 12 }, "_downloads": { "count": 429, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/sqlfluffr" }, "_devurl": "https://github.com/brendensm/sqlfluffr", "_searchresults": 2, "_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/sqlfluffr.html", "LICENSE", "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-07-04T21:47:16.000Z", "distro": "resolute", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "https://r2.ropensci.org/4127c3e95706795923053212ec569519adce0ffa944517714e7b5c689a6600e6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/28720525041" }, { "r": "4.6.1", "os": "linux", "version": "0.1.0", "date": "2026-07-04T21:47:17.000Z", "distro": "resolute", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "https://r2.ropensci.org/47355c30aec12da745357a5abc91ae2a1c969636265f3acc7c6de0bbd3700b18", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/28720525041" }, { "r": "4.5.3", "os": "mac", "version": "0.1.0", "date": "2026-07-04T21:46:53.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "https://r2.ropensci.org/b29391a94ab04185a3f0427b6d76c2ee1a7bc4e2e994324b929d819893016966", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/28720525041" }, { "r": "4.6.1", "os": "mac", "version": "0.1.0", "date": "2026-07-04T21:46:46.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "https://r2.ropensci.org/20bc458d760147bce0ebbca442387bfe23ac2e603d7c8764976fb8153635f24f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/28720525041" }, { "r": "4.6.0", "os": "wasm", "version": "0.1.0", "date": "2026-07-04T21:47:31.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "https://r2.ropensci.org/66ceb3b2a06dbee87657d8ec408bbbc473494862e8f62dd4264ff45695dd3eb2", "status": "success", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/28720525041" }, { "r": "4.7.0", "os": "win", "version": "0.1.0", "date": "2026-07-04T21:46:10.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "https://r2.ropensci.org/ca5f02a4b95dbdca038478780dbebb82d99581b24bb14b4223a726051c418b0c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/28720525041" }, { "r": "4.5.3", "os": "win", "version": "0.1.0", "date": "2026-07-04T21:46:07.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "https://r2.ropensci.org/83e5bd6cc4968f5c16cc5e3d9e2521a2aadbc3d397c907bd4c440b4906008e09", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/28720525041" }, { "r": "4.6.1", "os": "win", "version": "0.1.0", "date": "2026-07-04T21:46:12.000Z", "commit": "782d30e6c8fe4c8bfd2f6f986f91945d2d15455f", "fileid": "https://r2.ropensci.org/201ed8f21b5892e09b0ffaffa00d8796016bfc501fa402df28f9eb83b0be8d21", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/brendensm/actions/runs/28720525041" } ] }