use SQL::Abstract::More;
my $sql_builder = SQL::Abstract::More->new;

my ( $sql, @bind ) = $sql_builder->select(
    -columns => "id, site_id",
    -from    => "jobs",
    -where   => {
        id => [ 10 .. 20 ],
        first_seen_time => [
            "null",
            { "<" => time - 86400, ">" => time - 86400 * 8 }, 
        ],
    },
);

print " SQL: $sql\n\n";
print "BIND: @bind\n";'

...