On Mon, 29 Jul 2019 at 23:51, Rishi Solanki <[email protected]> wrote:
> Thanks for your input, I see delimited can be use for column names as well. > Are you proposing to limit it for entity alias name to wrap in the code as > I have reported it for that only. I'll convert a query and wait for input > from others. > Hi Rishi, There is less risk we'll see a problem with column names. A column name will be longer and more descriptive and less likely to collide with an SQL keyword. Aliases are more the danger, as you've found. However, if we do this at all we should do it for column names as well so a collision can never happen. That's better than hoping that anyone adding a new column knows what they're doing. Instead of a low risk of collision, we can be certain there's *no* risk. Cheers -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: [email protected]
