Veronika Heimsbakk sorry to respond here instead of at that original site, but from your question I would guess a VALUES clause might be what you are looking for?
Hi! No, it seems like there are no preferred solution to my question actually. Rather a string-based workaround. I posted the question on Twitter as well, ended up in a nice discussion: https://twitter.com/veronikaheim/status/1466678998885441536