Create SQL programmatically.

    my ($sql, @sql_params) = SELECT star,
        FROM( 'foo' ),
        WHERE match( 'bar', 'IN', SUBSELECT(
            ['id'],
            FROM( 'bar_tbl' ),
            WHERE match( 'baz', '>', 2 )
        ));