Subject Re: [Firebird-Architect] reserved words
Author Dmitry Yemanov
legrand_legrand_63 wrote:
> I have tried to port many applications to Firebird, and each time the
> more heavy work is to modify the source code to quote "Reserved words".
> [skip]
> COMPIERE port to Fyracle met the same problem, but the modification
> has been done in Fyracle ("Reserved words" are quoted during columns
> definition but no quote is needed in SQL statements).
> Could this kid of modification be available in Firebird ?

It violates the standard, sorry.

IMO, there are only two solutions possible. We either follow the SQL
spec that explicitly defines lists of both reserved and non-reserved
words and we expect people thinking about possible upgrades/migrations
and hence looking in the spec before naming their objects. Or we make
almost everything (what's technically possible) non-reserved.