It seems like you've got a custom format that you won't be able to use directly with SQL::Abstract, or SQL::Abstract::FromQuery and so on. That means you'll have to transform your input data anyway, whether you transform it to Perl data structures for use in those modules, or you transform it directly to SQL strings. If you do happen to choose the latter, then remember to always use DBI's quote, quote_identifier, and placeholders!