While the String class has many operators and methods I cannot find binary operators that concatenate Strings with literals, these would be useful for example when building a query string that may have literal parts and parts defined elsewhere in the code.
For example suppose we have a table name defined in a header file:
#define theTableName "tblName"
Then we want to build a query string:
String strQuery = "SELECT * FROM " + theTableName ;
This appears to not be possible with the String class.
Is there a way to do this, or do we have to build queries using the "string" class and then convert them to "String" to use them?