Small thing, but does anyone else hate manually formatting values for SQL IN clauses?

[sophi8876]

This feels like one of those tiny annoyances that adds up.

I often copy a list of IDs from logs / Excel / emails and need to drop them into a MySQL or Trino IN (...) clause. Half the time I end up manually adding quotes or commas, or fixing formatting errors when the query fails.

I’ve started using a small online utility (unblockdevs.com) that just converts raw lists into properly quoted values. Nothing fancy, but it removes a bit of friction from daily work.

Curious how others handle this — scripts, editor macros, or just manual cleanup?

[K_Anudeep]

Hey @sophi8876 ,

I generally use IDE' s like IntelliJ or VS Code and write a regex to add commas and quotes and it works for me and is faster enough as well