Option NAMEINSOURCE is de facto required for all the columns and tables. If it is not present then:
- column name in source query is not enclosed in back quotes - e.g. `$cb_t1`.ShortValue instead of `$cb_t1`.`ShortValue`
- name of the table is not added to the source query - e.g. SELECT ... FROM null `$cb_t1` LET ... WHERE ... instead of SELECT ... FROM `smalla` `$cb_t1` LET ... WHERE ...
This should work OOB without need to add NAMEINSOURCE option. Teiid should automatically translate column name from e.g. MyColumn to `MyColumn` if option is not set. Same with name of the table.
In case of table I think this is more serious as it does not even try name of the table but supplies null to the query