Thanks for your reply Victoria, I was looking for the option "Run Script", same as the one you find in standard buttons but I realise now that I can just create a JS "query" and trigger it and achieve the same result
Although, it would be nice to have that "Run Script" option directly in the button column so I can keep my list of queries more neatly organised. But it is definitely a nice to have rather than a must
We no longer support 'custom button' cells in tables with our current v2 tables.
If you want a cell click of a table to trigger a modal to open, you can configure that with a cell click event handler from the column's setup page in the inspector as shown below.