chore(engine/sql): specify the table name for the result set of queries with a join

A query on multiple tables should always specify the columns to retrieve.

related to #CAM-2957