How to work with jsonb (postgreSQL) through Yii2?

Question

PostgreSQL

Good day.
There is a project written in Yii2 and a database (PostgreSQL) that has quite a few fields in jsonb format. Tell me, in order to comfortably interact with them through the framework, are there any ready-made libraries or will you have to write SQL code directly in Yii2? An internet search turned up nothing good. Thanks in advance for your replies.

Answer 1

Подскажите, для того, что бы с ними комфортно взаимодействовать через фреймворк есть какие то готовые библиотеки или SQL код придется писать прямо в Yii2?

It all depends on what you will do with it. You need to understand that there are tasks for which the capabilities of the query builder are quite enough, and if its capabilities are not enough, you can always write a query in pure SQL