Hey any chance sorting would support
Hey any chance sorting would support nested JSON object keys? i can't directly use raw query since i need other stuff as well
4 Replies
Unfortunately this isn't currently in the roadmap so we don't expect movement in this area soon. The SQL example using the
->
operator in https://xata.io/docs/sdk/get#sorting-the-results is the way to go for now.The issue is that i am using other filters and sortings, if i go through the raw query route i will have to design the complete query myself
Perhaps you can give the Kysely integration a try? https://xata.io/docs/integrations/kysely It uses SQL underneath but abstracts behind a typescript-friendly query builder
i have never actually used kysely before so i am not sure how it works