PDO seems like the way to go to alleviate SSql's maintenance.
Note1: it's not possible to replace SSql with PDO entirely as it does not wrap in "named" connections as SSql does.
Note2: use of prepared statements seems preferable. Sacrifice current (pretend) multi database capabilities for the greater good of PDO prepared statements. It would be nice to re-use the debug connection stuff though as it's genuinely useful.
Note3: Orm currently does some SQL result caching and requires "rewind" functionality; this is not available in PDO.
PDO seems like the way to go to alleviate SSql's maintenance.
Note1: it's not possible to replace SSql with PDO entirely as it does not wrap in "named" connections as SSql does.
Note2: use of prepared statements seems preferable. Sacrifice current (pretend) multi database capabilities for the greater good of PDO prepared statements. It would be nice to re-use the debug connection stuff though as it's genuinely useful.
Note3: Orm currently does some SQL result caching and requires "rewind" functionality; this is not available in PDO.
Issue parked until Note3 is addressed.