1. Maybe you want to insert the results of the first query into the second one. This example shows how to do it with DBD::SQLite, some other databases can't have more than one prepared statement per db handle, so you'd need to connect more than once.
   Read more... (1436 Bytes)

2. Or you want to create a "SELECT INTO" statement. SQLite doesn't support this syntax directly, but features a similar construct that you can use:
   Read more... (1312 Bytes)

Assuming that you want to copy some columns from table1 to a new table2 based upon some parameters in table1 that won't even appear in table2, here is some code that was adapted from choroba's post:

#!/usr/bin/perl
use warnings;
use strict;
use feature qw{ say };

use DBI;

my $db = 'DBI'->connect('dbi:SQLite:;db=:memory:', "", "");

$db->do('CREATE TABLE t1 (id INT, name TEXT, quantity INT)');
$db->do('CREATE TABLE t2 (id INT, quantity INT)');

my $populate = $db->prepare(
    'INSERT INTO t1 (id, name, quantity) VALUES (?, ?, ?)');
    
$populate->execute(@$_)  #some test cases that don't start with 'J'
    for [ 1, 'John', 12 ],
        [ 2, 'Jane', 14 ],
        [ 3, 'Jack', 16 ],
        [ 5, 'Joe',  22 ],
        [ 5, 'bobo', 33 ],
        [ 23,'xyz',  44 ],
        [ 6, 'Josh', 27 ];

my $copy = $db->prepare("INSERT INTO t2 (id, quantity)
                         SELECT id, quantity
                         FROM t1
                         WHERE name LIKE ? AND id > ?");

$copy->execute('J%',2);

my $verify_t2 = $db->prepare('SELECT * FROM t2');
$verify_t2->execute;
my @row;
say "@row" while @row = $verify_t2->fetchrow_array;

__END__
Prints:
3 16
5 22
6 27
[download]

"In the simplest case, bind parameters are resolved left-to-right." If the query involves a subquery, it's still the same: "left to right."

Perhaps for this reason, though, it's also possible to find modules on CPAN that let you substitute the parameters symbolically: "where column1={col1} and..." They use the symbols to correctly build the parameter-list in proper order and then replace the symbols {col1} by the "?" that is required by SQL.

possible to find modules on CPAN

So, you actually know of at least one such module? And you're too much of an expert programmer to link it, or even name it? Wow. Thanks.