/sql-remove-comma

Removes illegal trailing commas from your SQL code

Primary LanguagePythonOtherNOASSERTION

sql-remove-comma

Tests Status Coverage Status

Dumb command line script that removes illegal trailing commas from your SQL code.

Intended as a preprocessor for SQL that allows you to use trailing commas like you should be able to. This makes diffs easier.

Usage

$ sql-remove-comma
$ cat queries.sql
SELECT
	x,
	y,
	z,
FROM tab;

	SELECT
		0 AS sort_order,
		x,
		y,
		z,
	FROM tab1
UNION ALL
	SELECT
		1 AS sort_order,
		a,
		b,
		c,
	FROM tab2
$ sql-remove-comma < queries.sql
SELECT 
	x,
	y,	
	z
FROM tab;
SELECT
		0 AS sort_order,
		x,
		y,
		z
	FROM tab1
UNION ALL
	SELECT
		1 AS sort_order,
		a,	
		b,
		c
	FROM tab2

License

BSD 2-clause + Patent. See the LICENSE file in this repository for details.