Jam::update() does not support joins

[hkdobrev]

Jam::update() should support the ->join() syntax similar to other builder methods in Jam.

Right now the only alternative is using the plain old Query Builder or plain text queries.

[ivank]

Yeah I know, that's a limitation of Kohana Database Module - to fix that properly we'll have to go deeper and modify Database Module. I even think that the old Query builder did not work either it just presented that interface.

For now you'll have to do this as a custom query.

[hkdobrev]

@ivank Actually when dug deeper the query builder of Kohana does not allow it as well.

[ivank]

@hkdobrev Yeah that's why I hope we're going to fix it when we extract the database module in a composer package.

[hkdobrev]

One more "+1" for this one. I am constantly using

UPDATE `updated_table_name`
JOIN `joined_table_name`
ON ...
SET

in migrations.