Description
A convenient interface for formatting 'SQL' queries directly within 'R'. It acts as a wrapper around the 'sql_format' Rust crate. The package allows you to format 'SQL' code with customizable options, including indentation, case formatting, and more, ensuring your 'SQL' queries are clean, readable, and consistent.
Downloads
301
Last 30 days
15468th
646
Last 90 days
2.3K
Last year
Trend: +107.6% (30d vs prior 30d)
26
Last 30 days
142
Last 90 days
373
Last year
Trend: -52.7% (30d vs prior 30d)
CRAN Check Status
Show all 13 flavors
| Flavor | Status |
|---|---|
| r-devel-linux-x86_64-debian-clang | NOTE |
| r-devel-linux-x86_64-debian-gcc | NOTE |
| r-devel-linux-x86_64-fedora-clang | NOTE |
| r-devel-linux-x86_64-fedora-gcc | NOTE |
| r-devel-windows-x86_64 | NOTE |
| r-oldrel-macos-arm64 | OK |
| r-oldrel-macos-x86_64 | OK |
| r-oldrel-windows-x86_64 | OK |
| r-patched-linux-x86_64 | NOTE |
| r-release-linux-x86_64 | NOTE |
| r-release-macos-arm64 | NOTE |
| r-release-macos-x86_64 | NOTE |
| r-release-windows-x86_64 | NOTE |
Check details (10 non-OK)
compiled code
File ‘SQLFormatteR/libs/SQLFormatteR.so’: Found non-API call to R: ‘R_NamespaceRegistry’ Compiled code should not call non-API entry points in R. See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual, and section ‘Moving into C API compliance’ for issues with the use of non-API entry points.
compiled code
File ‘SQLFormatteR/libs/SQLFormatteR.so’: Found non-API call to R: ‘R_NamespaceRegistry’ Compiled code should not call non-API entry points in R. See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual, and section ‘Moving into C API compliance’ for issues with the use of non-API entry points.
compiled code
File ‘SQLFormatteR/libs/SQLFormatteR.so’: Found non-API call to R: ‘R_NamespaceRegistry’ Compiled code should not call non-API entry points in R. See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual, and section ‘Moving into C API compliance’ for issues with the use of non-API entry points.
compiled code
File ‘SQLFormatteR/libs/SQLFormatteR.so’: Found non-API call to R: ‘R_NamespaceRegistry’ Compiled code should not call non-API entry points in R. See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual, and section ‘Moving into C API compliance’ for issues with the use of non-API entry points.
compiled code
File 'SQLFormatteR/libs/x64/SQLFormatteR.dll': Found non-API call to R: 'R_NamespaceRegistry' Compiled code should not call non-API entry points in R. See 'Writing portable packages' in the 'Writing R Extensions' manual, and section 'Moving into C API compliance' for issues with the use of non-API entry points.
compiled code
File ‘SQLFormatteR/libs/SQLFormatteR.so’: Found non-API call to R: ‘R_NamespaceRegistry’ Compiled code should not call non-API entry points in R. See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual, and section ‘Moving into C API compliance’ for issues with the use of non-API entry points.
compiled code
File ‘SQLFormatteR/libs/SQLFormatteR.so’: Found non-API call to R: ‘R_NamespaceRegistry’ Compiled code should not call non-API entry points in R. See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual, and section ‘Moving into C API compliance’ for issues with the use of non-API entry points.
compiled code
File ‘SQLFormatteR/libs/SQLFormatteR.so’: Found non-API call to R: ‘R_NamespaceRegistry’ Compiled code should not call non-API entry points in R. See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual, and section ‘Moving into C API compliance’ for issues with the use of non-API entry points.
compiled code
File ‘SQLFormatteR/libs/SQLFormatteR.so’: Found non-API call to R: ‘R_NamespaceRegistry’ Compiled code should not call non-API entry points in R. See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual, and section ‘Moving into C API compliance’ for issues with the use of non-API entry points.
compiled code
File 'SQLFormatteR/libs/x64/SQLFormatteR.dll': Found non-API call to R: 'R_NamespaceRegistry' Compiled code should not call non-API entry points in R. See 'Writing portable packages' in the 'Writing R Extensions' manual, and section 'Moving into C API compliance' for issues with the use of non-API entry points.
Check History
NOTE 13 OK · 1 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 27, 2026
compiled code
File ‘SQLFormatteR/libs/SQLFormatteR.so’:
Found non-API calls to R: ‘R_MissingArg’, ‘R_NamespaceRegistry’,
‘R_Srcref’, ‘R_UnboundValue’
Compiled code should not call non-API entry points in R.
See ‘Writing portable packages’ in the ‘Writing R Extensions’ manual,
and section ‘Moving into C API compliance’ for issues with the use of
non-API entry points.
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
Code
Structure
Lines of code
127
Files
25
Compiled share
6.3%
Has compiled src
Yes
Language breakdown
API
Exported functions
1
Internal functions
1
Recent export changes
Testing & CI
Has tests
Yes
Test-to-code ratio
0.30
testthat edition
3
CI present
No
CI type
[]
PR gated
No
Docs
Return-value doc rate
100%
\dontrun example ratio
0%
Roxygen coverage
100%
Has pkgdown
No
NEWS present
Yes
Health & Security signals
Informational signals; not verdicts.
on.exit coverage
–
Unsafe pattern score
0
Dep constraint coverage
0%
Secret pattern count
0
Bundled 3rd-party code
2 items
Portability & License
Min R version
4.2
System requirements
2
C++ standard
–
License
MIT + file LICENSE
License flags
SPDX valid, OSI approved
History
Versions
2
First release
2025-02-04
Latest release
2025-04-13
Avg cadence
68 days
Cold removal rate
–
Dep drift
0
LOC over versions
Per-file churn detail lives in the source pipeline: https://github.com/r-observatory/cran-code-metrics.