fix(Supabase Node): Allow for filtering on the same field multiple times

[dana-gill]

Summary

This PR allows filtering on the same field multiple times

Workflow for testing:

{
  "nodes": [
    {
      "parameters": {
        "operation": "getAll",
        "tableId": "my_table",
        "returnAll": true,
        "matchType": "allFilters",
        "filters": {
          "conditions": [
            {
              "keyName": "created_at",
              "condition": "gt",
              "keyValue": "={{ $json.greaterThan }}"
            },
            {
              "keyName": "created_at",
              "condition": "lt",
              "keyValue": "={{ $json.lessThan }}"
            }
          ]
        }
      },
      "type": "n8n-nodes-base.supabase",
      "typeVersion": 1,
      "position": [
        280,
        200
      ],
      "id": "59b409d0-4046-4612-b091-dca68d5bdefd",
      "name": "Supabase1",
      "credentials": {
        "supabaseApi": {
          "id": "f7FuHuk2EpV4d9bH",
          "name": "Supabase account"
        }
      }
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "df329893-69c7-49e4-bdba-5f44a2007e35",
              "name": "lessThan",
              "value": "2025-01-02 08:07:36.102231+00",
              "type": "string"
            },
            {
              "id": "f7080c12-08cd-41e4-9a2e-473d7bbdc775",
              "name": "greaterThan",
              "value": "2025-01-02 08:03:43.952051+00",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        40,
        200
      ],
      "id": "7acaee5c-393a-481f-8531-ab78039bbebd",
      "name": "Edit Fields"
    }
  ],
  "connections": {
    "Supabase1": {
      "main": [
        []
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Supabase1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {
    "Supabase1": [
      {
        "id": 4,
        "created_at": "2025-01-02T08:03:49.790638+00:00",
        "name": "jaja"
      },
      {
        "id": 5,
        "created_at": "2025-01-02T08:03:53.075208+00:00",
        "name": "lol"
      },
      {
        "id": 6,
        "created_at": "2025-01-02T08:07:33.870578+00:00",
        "name": "lol"
      }
    ]
  }
}

Related Linear tickets, Github issues, and Community forum posts

https://linear.app/n8n/issue/NODE-2107/community-issue-manual-filtering-bug-with-supabase

Closes #11998

Review / Merge checklist

• PR title and summary are descriptive. (conventions)
• Docs updated or follow-up ticket created.
• Tests included.
• PR Labeled with release/backport (if the PR is an urgent fix that needs to be backported)

[codecov]

Codecov Report

All modified and coverable lines are covered by tests ✅

📢 Thoughts on this report? Let us know!

[ShireenMissi]

Tested Manually as well and it works perfectly 🎉

[github-actions]

⚠️ Some Cypress E2E specs are failing, please fix them before merging

[cypress]

n8n    Run #8576

Run Properties:   Passed #8576  •  d7cc789d79: 🌳 master 🖥️ browsers:node18.12.0-chrome107 🤖 PR User 🗃️ e2e/*

Project	n8n
Branch Review	master
Run status	Passed #8576
Run duration	04m 55s
Commit	d7cc789d79: 🌳 master 🖥️ browsers:node18.12.0-chrome107 🤖 PR User 🗃️ e2e/*
Committer	Dana
View all properties for this run ↗︎

---

Test results
Failures	0
Flaky	4
Pending	0
Skipped	0
Passing	484
View all changes introduced in this branch ↗︎

[github-actions]

⚠️ Some Cypress E2E specs are failing, please fix them before merging

[github-actions]

⚠️ Some Cypress E2E specs are failing, please fix them before merging

[github-actions]

✅ All Cypress E2E specs passed

[janober]

Got released with [email protected]

[janober]

Got released with [email protected]

[janober]

Got released with [email protected]

[janober]

Got released with [email protected]