sqlformat: Format an SQL Query using sqlformat

In gadenbuie/sqrrrl: Utility Functions For Building SQL Queries

Description

Uses the python package andialbrecht/sqlparse to format an SQL query. See sqlformat -h for more information about formatting options.

Usage

sqlformat(sql, header = NULL, md = TRUE,
  sqlformat_options = "-k upper -a")

sqlsimplify(sql, ...)

Arguments

sql	SQL Query for formatting
header	Header added to formatted query as a comment
md	Add markdown backticks?
sqlformat_options	Options passed to sqlformat, see sqlformat -h for more information.

Functions

• sqlsimplify: Wrapper around sqlformat to simplify SQL statements.

gadenbuie/sqrrrl documentation built on May 24, 2019, 4:04 a.m.