AirQualityObserved SQL schema - as is a keyword

[rokf]

Hello,

I've noticed that the SQL schema file of the AirQualityObserved model contains a column that uses a keyword as the column name - as. It should be rewritten as "as" (quoted) to become usable.

https://github.com/smart-data-models/dataModel.Environment/blob/master/AirQualityObserved/schema.sql

Should these kind of things be fixed on a case by case basis or is there a generator for the SQL schema files that could be updated to fix these (keyword quoting) edge cases automatically?

Cheers 🙂

[albertoabellagarcia]

you are right we should modify the script (because this is created automatically)

[rokf]

I believe that I've found the script you're talking about and have opened an issue in the script's repository - smart-data-models/data-models#73.