At the moment, when I want to use a scalar function for a column, and the report is using the visual builder, I encounter this obstacle.
So the only way is extracting the SQL from the card, and creating a native query model, and then change on the SQL. But in my case we have many reports that are built using the visual builder, and I had to do this for 10 reports, it is very cumbersome.
If would be possible to use the function (since it’s present on the database, and the card is connected to the same database) directly on the visual builder on the Custom Column, that would help a lot, and make things a lot faster.