my $stmt = qq[SELECT * FROM (SELECT "id", "vorname", "nachname", ROW_NUMBER() OVER (PARTITION BY "vorname","nachname" ORDER BY "id" ASC) AS "rn" FROM "namen") "t1" WHERE "rn" > ?];
my $nr = 1;

my $sth = $dbh->prepare( $stmt );
$sth->execute( $nr );
say $sth->dump_results();

say "============";

$dbh->{sqlite_see_if_its_a_number} = 1;
$sth = $dbh->prepare( $stmt );
$sth->execute( $nr );
say $sth->dump_results();

0 rows
0
============
7, 'Lena', 'Müller', 2
6, 'Max', 'Mustermann', 2
2 rows
2

if ( looks_like_number $value ) {
    return $value;
}
else {
    return $dbh->quote( $value );
}

if ( $dbh->{sqlite_see_if_its_a_number} ) {
    if ( looks_like_number $value ) {
        return $value;
    }
    else {
        return $dbh->quote( $value );
    }
}
else {
    if ( $is_numeric_data_type{$col} ) {
        return $value;
    }
    else {
        return $dbh->quote( $value );
    }
}