Format data in tables as a link

I’m listing records from one of our database tables for our admins. And each of these records have a page in our application accessible via URL (eg. website.com/resource/1 - where 1 is the ID).

Now, is there a way I can format either the ID or Name field in the table as a link so that my users can simply access the above mentioned page directly from the Metabase table?

Related GitHub issue, where I recently added a comment summarizing different proposed solutions:

I’ll see if I can shortly find and amend with link to current available workaround (basically dropping to SQL string concatenation to build URLs)