How to improve Spectrum Spatial FeatureService Search By SQL functionality

Specify the fully-qualified name of each field in cases where there's ambiguity and surround that field name in double quotes.  For example

select "/NamedTables/AccountsTable.cid", "/NamedTables/AccountsTable.address", "/NamedTables/ReferenceTable.refcolumn" from "/NamedTables/AccountsTable", "/NamedTables/ReferenceTable" where "/NamedTables/AccountsTable.cid"="/NamedTables/ReferenceTable.cid"

 
UPDATED:  October 4, 2017