use DBI; my $dbh = DBI->connect('DBI:RAM:','usr','pwd',{RaiseError=>1}); $dbh->func({ table_name => 'my_phrases', col_names => 'id,phrase', data_type => 'PIPE', data_source => [], }, 'import' ); print $dbh->selectcol_arrayref(qq[ SELECT phrase FROM my_phrases WHERE id = 1 ])->[0]; __END__ 1 | Hello, New World 2 | Some other Phrase