I am wondering if there is a way to show custom "values" in the output of a query purely for readability, similar to the
AS statement for renaming column labels.
Seems unlikely but would be useful for cutting down a number of custom post-query formatting steps.
| type (varchar) | status (boolean) | | A | t | | B | f |
| type | status | | A | true | | B | false |
| type | status | | A | collecting | | B | disabled |
I am aware I could change the database to contain these values, but this is not possible in this case.