The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

SQLFormatteR

SQLFormatteR is an R package that provides an easy-to-use wrapper for the sqlformat-rs Rust-based SQL formatter. It allows you to format SQL queries with support for various SQL dialects directly in R.

Features

• Simple and seamless integration with R.
• Maintains SQL query readability and consistency.
• Supports standard SQL formatting options.

Limitations

• Does not support formatting stored procedures.
• Only supports the ; delimiter for SQL statements (custom delimiters are not available).

Installation

You can install SQLFormatteR from GitHub using:

# Install devtools if not already installed
if (!requireNamespace("remotes", quietly = TRUE)) install.packages("remotes")

remotes::install_github("dataupsurge/SQLFormatteR")

Usage

library(SQLFormatteR)

sql_query <- "SELECT * FROM users WHERE age > 18 ORDER BY name;"

formatted_sql <- sql_format(sql_query)

cat(formatted_sql)

Contributing

We welcome contributions! Feel free to submit issues or pull requests to improve the package.

License

This project is licensed under the MIT License. See the LICENSE file for details.

It depends on sqlformat-rs, which is also licensed under MIT.

When distributing this package, you must retain the original MIT license notice.

⭐ If you find this package useful, please consider giving it a star on GitHub!

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.