my $sqla = SQL::Abstract::More->new;

my $time   = time;
my $status = 'active';

my ( $sql, @bind ) = $sqla->select( # new users yesterday
    -columns => 'id, name',
    -from    => 'users',
    -where   => {
        status          => $status,
        first_seen_time => {
            '>'  => $time - 86400,
            '<=' => $time,
        },
    },
);