DelightQL is a query language that transpiles to SQL. Its syntax draws on logic and functional programming to make queries succinct and reusable. It offers the traditional abstractions of a modern programming language while retaining all of SQL's relational power.

I have started dev tool for myself and now decided to release it. Maybe will be usefull for backend developers or those who are starting to learn sql Link to devtool: https://isra36.com/ Link to its documentation: https://isra36.com/documentation MySQL & PostgreSQL

Putting aside any opinions on performance, I've been trying to test a notion about whether a couple queries would output the same data (ordering doesn't matter).

SELECT *
FROM articles
WHERE (
  last_updated >= %s
  OR id IN (1, 2, 3)
  )
  AND created_at IS NOT NULL

SELECT *
FROM articles
WHERE last_updated >= %s
  AND created_at IS NOT NULL
UNION
SELECT *
FROM articles
WHERE id IN (1, 2, 3)
  AND created_at IS NOT NULL

I think they're equivalent, but I can't prove it to myself.

Edit: Aye, looking at the replies, I'm becoming aware that I left out a couple key assumptions I've made. Assuming:

a) id is a PRIMARY KEY (or otherwise UNIQUE)

b) I mean equivalent insofar as "the rows returned will contain equivalent data same (though maybe ordered differently)"