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();