I have thought that I want to share as a semi pro programmer. Nowadays it is so easy to ask an agent to code for you that every moment you spend coding seems like a waste. I am not even talking about the reasoning or planning, but the actual typing out. Even if I understand perfectly well what I want and how to type it, it is still faster and less error prone to ask the llm to do it. It is fine, but no fun. Also I can never be sure that the llm did the thing I had in mind. For exploratory programming and analysis I rather try 100 different queries my self, but then I have to type endlessly (which I may optimize in time, but not if I have a new quest or project where I need to look around first).
I want a very very coarse language that I can wrap around maybe an existing language, maybe after asking an llm to create an adapter that will allow me to type faster than the llm
Say
SELECT c.name, c.email, SUM(o.total) AS spent
FROM customers c
JOIN orders o ON o.customer_id = c.id
JOIN addresses a ON a.customer_id = c.id
WHERE a.country = 'AR'
AND o.created_at >= '2026-01-01'
AND o.status <> 'cancelled'
GROUP BY c.id, c.name, c.email
HAVING SUM(o.total) > 1000
ORDER BY spent DESC
LIMIT 10;
bluepoint · · focus · HN ↗
I want a very very coarse language that I can wrap around maybe an existing language, maybe after asking an llm to create an adapter that will allow me to type faster than the llm
Say SELECT c.name, c.email, SUM(o.total) AS spent FROM customers c JOIN orders o ON o.customer_id = c.id JOIN addresses a ON a.customer_id = c.id WHERE a.country = 'AR' AND o.created_at >= '2026-01-01' AND o.status <> 'cancelled' GROUP BY c.id, c.name, c.email HAVING SUM(o.total) > 1000 ORDER BY spent DESC LIMIT 10;
and compress it to
c+o+a|a.cn=AR,o.d>26,o.st!X|c:nm,em,$tt>1k|v10
(I made up a random example with claude).
I know about J and Q but they cannot be used with sql databases or existing python libraries.
Anyway. I am not sure if anyone has such concerns.