squish_sql {queryparser}

Squish a SQL query or SQL expression

Description

Replaces every unquoted run of whitespace characters with a single space and removes all line comments (--) and block comments (/* */). Whitespace and comment marks within quotes are not modified.

Usage

squish_sql(x)

Arguments

x

a character string containing a SQL query or expression

Value

a character string containing the squished query or expression with comments removed