KohanaPHP » Kohana v3.x

It is `:` (colon char) used in alias name in `Kohana_ORM::with()` implementation and it is a denied char to use in postgresql (at least without quoting)

Database_Exception: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ":" 
LINE 1: SELECT type.pk AS type:pk, type.id AS type:id, type.name AS ...
                              ^ [ SELECT type.pk AS type:pk, type.id AS type:id, type.name AS type:name, type.valid_from AS type:valid_from, type.valid_to AS type:valid_to, type.tx_from AS type:tx_from, type.tx_to AS type:tx_to, locationstub.* FROM location AS locationstub LEFT JOIN location_type AS type ON (type.pk = locationstub.location_type_id) WHERE id = 1 AND NOW() BETWEEN tx_from and tx_to AND NOW() BETWEEN valid_from and valid_to LIMIT 1 ]