After implementation of TEIID-4298 it is possibile the reverse navigation using the FK.
Anyway the following behaviour is still not permitted
The message returned is
The property 'Products' must not follow a collection
That would only possible of Products and Categories implemented as in product to category implemented as 1 to 1 relation, and reverse is 1 to many, how is it defined your DDL? Still I am not sure Teiid supports that yet. You can re-open the JIRA with these specifics.