I've been watching the development of #BeekeeperStudio as an interesting cross-platform #SQL database GUI, and they just rolled out a charming feature they call "query magics." They're standards-compatible column alias modifiers you can use in a SELECT query to format the output.
For instance:
SELECT review_score AS rating__format__stars__5…
Will return integer data as ★★★☆☆
I think it's neat. Demo video in docs:
https://docs.beekeeperstudio.io/user_guide/query-magics/??utm_source=newsletter&utm_medium=email&utm_campaign=querymagicsnov25


