Sort by property of Json field

[fgrande]

Problem

At the moment looks impossible - through Prisma - to define sort order by property of json field. Postgres allow this with the following syntax (for instance):

select id, "additionalFields"->'jsonProperty'->>'fieldName' from "Table" t
order by "additionalFields"->'jsonProperty'->>'fieldName' desc

Suggested solution

Associate a new SortOrderJson class to json fields, where a property "path" can define the property to sort for

[Druue]

This seems to be possible in our other sql providers as well 👍

• mysql
• sqlserver
• sqlite