You can generate a mapping from an SQL query in the Developer tool. You can create or paste an SQL statement in the Generate Mapping or Logical Data Object from SQL Query dialog box, or load a text file that contains an SQL query. Optionally, you can define or redefine the source of the query table. The Developer tool validates the SQL query and generates a mapping.

You can also generate a logical data object from an SQL query that contains only SELECT statements.