Re:Ask HN: LISPers, do you use homoiconicity (code-as-data)?
by db48x on Tuesday January 26, 2021 @12:11AM
(#25912816)
Embedded SQL is also quite common.
[ Parent
| on HN ]
Re:Ask HN: LISPers, do you use homoiconicity (code-as-data)?
by harperlee on Tuesday January 26, 2021 @07:20AM
(#25914977)
Yes but in my experience (with korma, which I don't like) I've not used a lot of programmatic modification of SQL queries. At the end of the day, I write a query for "a data question", and I add parameters to the question, but it is rare for me that I need to "create new types of questions" on the fly.
Even if I need to compose a query for a more flexible questioning than using a value parameters, this is something that typically could be done by combining 2 or 3 substrings, there is not typically the need to work queries as much as I do with HTML and hiccup.
So at the end I moved to HugSQL (the modern+popular "write your queries in SQL"-philosophy library) instead of YesQL (the modern+popular "write your queries in clojure"-philosophy library, similar in approach to korma).
Re:Ask HN: LISPers, do you use homoiconicity (code-as-data)?
by db48x on Tuesday January 26, 2021 @07:43AM
(#25915170)
Yes, sometimes that suffices. Other times you have to translate an ad–hoc query language encoded in the query parameters of a url into SQL queries, and then it would be really nice to have some way of manipulating them other than just string concatenation. That's a month of my life I’ll never get back.