SQL: CASE WHEN

[sergey-telpuk]

Hello!
How can I make up the following sql:

SELECT a,
       CASE WHEN a=1 THEN 'one'
            WHEN a=2 THEN 'two'
            ELSE 'other'
       END
    FROM test;

[roxblnfk]

Look at this: cycle/database#47

In your case it could be like this:

$query->columns([
    'a',
    new Fragment('CASE WHEN a = ? THEN ? WHEN a = ? THEN ? ELSE ? END', 1, 'one', 2, 'two', 'other'),
]);