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, ...)
sql | SQL Query for formatting |
---|---|
header | Header added to formatted query as a comment |
md | Add markdown backticks? |
sqlformat_options | Options passed to |
sqlsimplify
: Wrapper around sqlformat to simplify SQL statements.