fuel/core — Issue #622: PostgreSQL - DB->update()->set() fails when column name is pgsql reserved word
Author: darklow
Created: 2011-10-28 12:31:21+00:00
State: open

```php

$update_array = array(
'"cast"'	=> 'test',
'crew'	=> 'test'
);

$q = \Db::update('table')->set($update_array)->where('id', $id)->execute();
```

Throws an SQL error:

```
Fuel\Core\Database_Exception [ Error ]: SQLSTATE[42601]:
Syntax error: 7 ERROR: syntax error at or near "cast" LINE 1: UPDATE item_movie SET cast = '', ...
```

Because DB builder removes quotes from column names and *cast* is reserved word in postgresql, there is no way i can update table using DB->update() method in this case.

Also i can't use DB::expr() object as array key.

Maybe there must be some workaround added, so that quotes wont be removed?
Or probably other solution would be add columns() values() methods to Database_Query_Builder_Update. So i could use DB::expr() for column name.