Option NAMEINSOURCE is de facto required for all the columns and tables. If it is not present then:

1. column name in source query is not enclosed in back quotes - e.g. `$cb_t1`.ShortValue instead of `$cb_t1`.`ShortValue`
2. 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