Multiple Spaces are squashed into one

When I try the following in pgAdmin or SSMS

 select concat('a', '             ', 'b')

I get

a             b

But running that in Metabase gives a b. How can I prevent squashing multiple spaces into one in Metabase?

Hi @King_Edward
That's a feature of HTML. You are looking for something like this:
https://github.com/metabase/metabase/issues/11207 - upvote by clicking :+1: on the first post