Exactly my first thought.
Happy user of PugSQL here. I just wish there was a VSCode extension for autocompletion.
Re:Simple SQL in Python
by nackjicholson on Thursday August 13, 2020 @11:57PM
(#24153163)
I haven't used pug, but I read through it a bit and like their approach. I think they have a more intricate way of parsing SQL than we have in aiosql. We're doing it quick and dirty with some regular expressions.
Re:Simple SQL in Python
by TedDoesntTalk on Thursday August 13, 2020 @02:15PM
(#24146357)
> I'd say an advantage of pugSQL is that
Plus it’s got a cool name
Re:Simple SQL in Python
by config_yml on Thursday August 13, 2020 @11:48AM
(#24144616)
is there something like this for ruby?
[hp]ugSQL seems to have been inspired by[1] Yesql, a library with ``a similar take on using SQL'' that has also inspired this[2] rom-rb adapter; not a Ruby guy so there may be something a lot better/closer, but this is what I came up with after a couple minutes of searching.
[1] https://www.hugsql.org/#faq-yesql
[2] https://github.com/rom-rb/rom-yesql (documentation: https://www.rubydoc.info/gems/rom-yesql)
I'd say an advantage of pugSQL is that it's sqla-core under the hood, so lots of stuff will Just Work and you can drop down to core to commit war crimes if you have to.