How to convert SQL to AML

Beacause large amount for data result, so performance of method above will slower than SQL query ? Further: with case as below, process will difficult and slow than more if not used query SQL SELECT * FROM ABC XXX INNER JOIN (SELECT MP.* , (CASE WHEN MN.keyed_name IS NULL Then ‘1’ ELSE MN.keyed_name END) AS MN_keyed_name FROM Manufacturer_Part MP LEFT JOIN Manufacturer MN ON(MP.manufacturer = MN.ID) WHERE ( MP.ITEM_NUMBER = ‘CPART5566a’ AND MP.manufacturer IS NULL ) OR ( MP.ITEM_NUMBER = ‘CPART5566a’ AND MN.keyed_name = ‘MAKRT5566b’ ) ORDER BY modified_on) YYY ON(XXX.ITEM_NUMBER = YYY.ITEM_NUMBER AND XXX.keyed_name = YYY.keyed_name)

Beacause large amount for data result, so performance of method above will slower than SQL query ? Further: with case as below, process will difficult and slow than more if not used query SQL SELECT * FROM ABC XXX INNER JOIN (SELECT MP.* , (CASE WHEN MN.keyed_name IS NULL Then ‘1’ ELSE MN.keyed_name END) AS MN_keyed_name FROM Manufacturer_Part MP LEFT JOIN Manufacturer MN ON(MP.manufacturer = MN.ID) WHERE ( MP.ITEM_NUMBER = ‘CPART5566a’ AND MP.manufacturer IS NULL ) OR ( MP.ITEM_NUMBER = ‘CPART5566a’ AND MN.keyed_name = ‘MAKRT5566b’ ) ORDER BY modified_on) YYY ON(XXX.ITEM_NUMBER = YYY.ITEM_NUMBER AND XXX.keyed_name = YYY.keyed_name)