my $sql = <<"SQL";
    INSERT INTO $table ($column) VALUES (?)
    RETURNING id
SQL

my $sth = $dbh->prepare($sql);
$sth->execute(...);
my $rows = $sth->fetchall_arrayref( {} );
say "New id: " . $rows->[0]->{id};