Re:Getting AI to write good SQL
by mritchie712 on Friday May 16, 2025 @09:33PM
(#44011364)
The JSON compiles to SQL. Have you used a semantic layer? You might have a different opinion if you tried one.
[ Parent
| on HN ]
As someone who actually wrote a JSON to (limited) SQL transpiler at $DAYJOB, as much fun as I had designing and implementing that thing and for as many problems it solved immediately, 'tail wagging the dog' is the perfect description.
SELECT email FROM users WHERE deleted_at IS NOT NULL OR status = 'active'
{
"_select": "email",
"_table": "users",
"_where": {
"deleted_at": { "_is": { "_not": SQL_NULL_VALUE } },
"_or": [
{ "status": "inactive" },
]
}
}