Ru:OSQL

SELECT

<?php
OSQL::select()->
    get(DBField::create('id'))->
    get(DBField::create('name'))->
    get(DBField::create('age'))->
    from(User::dao()->getTable())->
    where(
        Expression::ilike(
            new DBFiled('name'),
            'Joh'
        )
    );
?>

UPDATE

<?php
?>

DELETE

<?php
OSQL::delete()->
    from('table')->
    where(
        Expression::lt('id', 1000)
    );
?>