Is it possible to implement mutable update of a array field by slick-pg query?

[vasyaod]

If I have a raw query like:

sqlu"""UPDATE table1
         SET events = events || $event::jsonb
          WHERE field1 = $value1”””

Is it possible write request by slick-pg like:

table
  .filter(t => t.field1 === $value1)
  .map(t => t.events + $event)
  .update($event)

[tminglei]

@vasyaod you can use slick mutator API, for its usage you can see the tests for details.