Possible to do INSERT with some columns from SELECT query and some columns with specific values?
Literal must be a column in output list simply:
INSERT into ORDERS (cust_id,   rep_id , sku_ordered) 
SELECT                id   , sales_rep,   'ABC123'
from CUSTOMERS 
where cust_name = 'ABC Corp';