Meaning of blue/purple text in query layer

AmyRoust

In this ArcGIS Pro query layer, one of my field names turns blue/purple:

When I publish the layer in a web service, it gets quotes around it:

The quotes are causing issues with related tables. Why do they appear, and is there any way I can get rid of them? I've tried adding AS [Level] as an alias, but the quotes still appear in the service.

jcarlson

In Oracle at least, "LEVEL" is a keyword. It would be like naming your column "INT" or something, and the publishing process probably just quotes it out to avoid messing up the queries going on with the database. Could you try an abbreviation like "lvl"?