🧽 SpOnGeCaSqL

(spongecaSQL)

SQL is great but it is not case-sensistive. Which means that keywords and objects can be called in UPPERCASE or in _lowercase .

That's bad. It discourage consistency since some developer will write SELECT, select or even Select.

Here is a standard to fix this issue : 🧽 SpOnGeCasE.

Usage

$ python3 spongecasql.py yourfile.sql

Before

/*
    Comments are ignored
*/
# Those too
-- Those too
SELECT *  
FROM Customer
WHERE country = 'US'
AND city = 'New-York City'

After

/*
    Comments are ignored
*/
# Those too
-- Those too
sElEcT *  
FrOm cUsToMeR
WhErE CoUnTrY = 'US'
AnD CiTy = 'New-York City'