Basically, every time I sql.join used with literals, sql.array would have been a lot better.

This is further explained here: https://github.com/gajus/slonik?tab=readme-ov-file#sqlarray-vs-sqljoin

sql.join with literals will be dropped in the next major version.