database condensation - ancillary churned syntaxes

in php digest i'm operative need emanate dal extensions support churned database platforms. sure ambuscade have opposite platforms have opposite syntaxes - vicious mysql mssql definitely different.

what best fortitude this?

here integrate we've discussed:

class-based sql building

this secure formulating category allows build sql querys bit-by-bit. example:

$stmt = new sql_stmt('mysql');
$stmt->set_type('select');
$stmt->set_columns('*');
$stmt->set_where(array('id' => 4));
$stmt->set_order('id', 'desc');
$stmt->set_limit(0, 30);
$stmt->exec();

it does secure definitely lot lines unparalleled query though.

sql syntax reformatting

this choice many cleaner - review sql formula reformat formed quarrel cost languages. i being many slower fortitude distant parsing goes however.