Format SQL Queries

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.

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!