fix(supabase): nested embedded resources sorting

[youssefsiam38]

PR Checklist

Please check if your PR fulfills the following requirements:

• [x] The commit message follows our guidelines: https://refine.dev/docs/guides-concepts/contributing/#commit-convention

Bugs / Features

• [ ] Related issue(s) linked
• [x] Tests for the changes have been added
• [ ] Docs have been added / updated
• [x] Changesets have been added https://refine.dev/docs/guides-concepts/contributing/#creating-a-changeset

What is the current behavior?

When sorters value is

[
    {
        "field": "posts.categories.tags",
        "order": "asc"
    }
]

The resulted url query param

posts.order=categories.tags.asc

What is the new behavior?

When sorters value is

[
    {
        "field": "posts.categories.tags",
        "order": "asc"
    }
]

The resulted url query param

posts.categories.order=tags.asc

Notes for reviewers

Postgrest documentation

[changeset-bot[bot]]

🦋 Changeset detected

Latest commit: df5600f315f05f62591e43fe1ed8df703a5ffc54

The changes in this PR will be included in the next version bump.

This PR includes changesets to release 1 package

| Name | Type | | ------------------- | ----- | | @refinedev/supabase | Patch |

Not sure what this means? Click here to learn what changesets are.

Click here if you're a maintainer who wants to add another changeset to this PR