'Additional Postgres functions in Peewee

Apologies if this question has been answered before. I'm quite new to Peewee, and am confused from the documentation how to query using more custom Postgres commands. Specifically, I am trying to use the jsonb functionality outlined in https://www.postgresql.org/docs/9.5/functions-json.html.

For example, UPDATE table SET value = value || '[new value]'.

So far, I have only had to use very basic peewee functionality such as

where = (querybuilder.name == name) 
querybuilder.select(querybuilder.value).where(where)

I have noticed that peewee has an execute_sql command for more custom functionality, however I've had some issues getting this to work, and am looking to see if something more built-in to peewee exists.

Thank you!!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source