[TORQUE-305] Do insert with a select subquery

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0
• Fix Version/s: 5.0
• Assignee: Thomas Fox
• Reporter: Michael Wagner
• Created: 13/Nov/13 09:44
• Updated: 27/Dec/13 23:02
• Resolved: 27/Dec/13 23:02

Description

It would be nice if the torque criteria api would support inserts with a given sub query like the following:

INSERT INTO table_a (column_a, column_b, column_c)
SELECT
/* Literal number values with column aliases */
value_a AS column_a,
value_b AS column_b,
column_x
FROM table_b
WHERE ...;