...and using the DBI func method will pull out the value for you after an insert:

    $dbh->do( q{
        CREATE TABLE foo (
            id integer not null primary key,
            name varchar(20)
        )
    });
    $dbh->do( "INSERT INTO foo ( name ) VALUES ( 'bar' )" );
    print "ID of record: ", $dbh->func( 'last_insert_rowid' ), "\n";
[download]