But "you" could write a IntelliJ plugin to add an action to generate the queries

# squarelibraries

[hfhbd]

But "you" could write a IntelliJ plugin to add an action to generate the queries

[glureau]

Does a live template could also do the job?

[hfhbd]

I don't know, maybe I guess, but I never wrote explicitly plugin code for a live template, sorry.

[glureau]

Can't test right now, just to share the idea if it can help @Adam S

[Adam S]

cool, thanks @glureau, I’ll give it a go.

[Adam S]

the SQDelight IJ plugin could add these templates?

[hfhbd]

AFAIK we have some templates already: https://github.com/cashapp/sqldelight/blob/master/sqldelight-idea-plugin/src/main/kotlin/app/cash/sqldelight/intellij/actions/GenerateSelectAllQueryAction.kt

[Adam S]

so you do 👍

[hfhbd]

If you want to provide more default queries, a PR would be welcome (I guess).

I don't know how powerful live templates are.
If you need queries specific for your business, you could create an IntelliJ plugin, add sqldelight plugin as dependency and extend the actions. But keep in mind, the api of the sqldelight IntelliJ plugin is not stable.

[Adam S]

haha don’t tempt me @hfhbd, I’m already 4 or 5 steps off track https://en.wiktionary.org/wiki/yak_shaving

[hfhbd]

Ha, never head this word, nice. I only know this gem:

https://www.youtube.com/watch?v=AbSehcT19u0▾

[Adam S]

exactly!

[psh]

Jetbrains Datagrip does a great job wrangling SQL - select * from ____ can be expanded into a list of fields, etc. What you get for Kotlin in Intellij is available for SQL in Datagrip. It made my life so much easier