Format output in SQL or in Ignition?

I have heard that best practice logic about SQL also. And it is just that. A best practice, not the law.

All I can say is, if your SQL server is not bogging down doing this, why not use it? You aren’t changing anything in the SQL table. You are just modifying the format of the output in a query, or view in this case. I see nothing wrong with that. If this were very processor-intensive, you might want to experiment to see whether SQL or Ignition would be best for your system overall. In what you are doing here, I would suspect it is not processor-intensive, so I would go with whatever method I preferred.