Format an SQL Query using sqlformat

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

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.