Feature Proposal: Column-Level DELETE Operation in SQL

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Abhishek Hatgine <[email protected]>
To: [email protected]
Subject: Feature Proposal: Column-Level DELETE Operation in SQL
Date: Mon, 21 Apr 2025 22:23:30 +0530
Message-ID: <CAD2voTQMUmNCKBok-_HvYLqFNECRWNkvqPruq0NcsFgd6g-Odw@mail.gmail.com> (raw)

*Dear SQL Development Team,*

I hope this message finds you well.

I'd like to propose a new feature for consideration in future versions of
SQL — the ability to perform a column-level DELETE operation, allowing
removal of specific column values without affecting the entire row.

*Proposal Summary*

Currently, SQL provides two core commands:

   -

   DELETE – to remove entire rows.
   -

   UPDATE – to change or nullify column values.

However, there’s no specific, expressive way to *delete the value of a
column* directly. The typical workaround is to use:

UPDATE Customers SET Address = NULL WHERE CustomerID = 103;

While this works fine, it doesn't semantically express that the developer
intends to *remove* the value — not just update it.

*Proposed Syntax Examples*

Here are some ideas for possible new syntax:

DELETE Address FROM Customers WHERE CustomerID = 103;-- or
REMOVE COLUMN Address FROM Customers WHERE CustomerID = 103;

And even:

DELETE Address, PostalCode FROM Customers WHERE Country = 'India';

These would act as a shortcut or expressive alias for setting one or more
column values to NULL.

*Why This Matters*

   -

   *Improved readability* and code clarity.
   -

   More intuitive for developers coming from languages or NoSQL systems
   where fields can be "deleted" from an object/document.
   -

   Emphasizes intent: *deleting* a value is conceptually different from
   *updating* it to NULL.
   -

   Opens doors for potential enhancements in tooling and IDE support.

I understand this would require careful consideration within the SQL
standards, but I believe it could make SQL more expressive and
beginner-friendly while preserving its power.

Thank you for your time and for all the work you do to maintain and improve
SQL systems.

Warm regards,
*Abhishek Hatgine*
SQL Learner
Your Email – [email protected]
Location – Pune

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Feature Proposal: Column-Level DELETE Operation in SQL
  In-Reply-To: <CAD2voTQMUmNCKBok-_HvYLqFNECRWNkvqPruq0NcsFgd6g-Odw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox