CRM_Utils_SQL_Insert

Dear God Why Do I Have To Write This (Dumb SQL Builder)

Usage: $insert = CRM_Utils_SQL_Insert::into('mytable') ->row(array('col1' => '1', 'col2' => '2' )) ->row(array('col1' => '2b', 'col2' => '1b')); echo $insert->toSQL();

Note: In MySQL, numeric values may be escaped. Except for NULL values, it's reasonable for us to simply escape all values by default -- without any knowledge of the underlying schema.

Design principles: - Portable - No knowledge of the underlying SQL API (except for escaping -- CRM_Core_DAO::escapeString) - No knowledge of the underlying data model - Single file - SQL clauses correspond to PHP functions ($select->where("foo_id=123"))