Вот что я "наворотил":

INSERT INTO components (ware_id, component_reference_id, drawing_id, workpiece_id)
VALUES ((SELECT ware_id FROM ware WHERE drawing_id =
(SELECT drawing_id FROM drawings WHERE drawing_number = '%1')),
(SELECT component_id FROM components WHERE drawing_id =
(SELECT drawing_id FROM drawings WHERE drawing_number = '%1')),
(SELECT drawing_id FROM drawings WHERE drawing_number = '%1'),
(SELECT workpiece_id FROM workpieces WHERE component_id =
(SELECT drawing_id FROM drawings WHERE drawing_number = '%')))

Можно ли этот огород делать культурнее?

Подсоветуйте, ПЛЗ.
Спасибо!