[FEATURE] Support `UPSERT` `REPLACE` in `sqlVerbs` and in front end grammar

Open

#97 opened on Aug 23, 2024 0 comments 0 reactions 1 assignee View on GitHub

@general-kroll-4-life is already working on this.

Since Aug 23, 2024.

Assessment

This issue has not been assessed yet.

Description

enhancement

Feature Description
support
~~UPSERT~~ REPLACE as an alias to UPDATE, helps to differentiate put and patch methods with the same signatures

Example(s)

for the following DML operation:

UPSERT INTO google.compute.firewalls
SET field1 = 'value1'
WHERE project = 'my-project'
AND firewall = 'my-firewall'

would use this resource definition...

    firewalls:
      id: google.compute.firewalls
      name: firewalls
      title: Firewalls
      methods:
...
        update:
          operation:
            $ref: '#/paths/~1projects~1{project}~1global~1firewalls~1{firewall}/put'
          response:
            mediaType: application/json
            openAPIDocKey: '200'
        patch:
          operation:
            $ref: '#/paths/~1projects~1{project}~1global~1firewalls~1{firewall}/patch'
          response:
            mediaType: application/json
            openAPIDocKey: '200'
      sqlVerbs:
...
        upsert:
          - $ref: '#/components/x-stackQL-resources/firewalls/methods/update'
        update:
          - $ref: '#/components/x-stackQL-resources/firewalls/methods/patch'
...

to access the upsert route, treated the same as and update but routed to the proper operation in the path

Dominant language: Go
Stars: 0
Forks: 0
PR merge metrics: No merged PRs in 30d

Contributor guide

Open the contributing guide

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Similar issues

math/big: Rat.GobDecode accepts negative zero Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

golang/go#81645 · 1 comment · Opened Sep 22, 2026
GrafeasNote is a duplicate resource of ContainerAnalysisNote Open

Difficulty 1/5 Under an hour Newbie friendliness 84/100

GoogleCloudPlatform/k8s-config-connector#13349 · Opened Sep 21, 2026
[receiver/receiverhelper] skip WithLinks when the parent span context is invalid Open

enhancement needs triage

Difficulty 2/5 1-3 hours Newbie friendliness 68/100

open-telemetry/opentelemetry-collector#15998 · Opened Sep 21, 2026
🧹 Use PodSet wrappers in DRA tests Open

kind/cleanup

Difficulty 2/5 1-3 hours Newbie friendliness 88/100

kubernetes-sigs/kueue#15947 · Opened Sep 21, 2026
Custom provider credential is written as `PROVIDER_API_KEY` (apiserver) but the AgentRun controller injects only allowlisted keys, so every custom provider fails with HTTP 401 Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

sympozium-ai/sympozium#627 · Opened Sep 21, 2026

More Go issues

[FEATURE] Support ~~`UPSERT`~~ `REPLACE` in `sqlVerbs` and in front end grammar