I am trying to translate the data into a humanized/readable state from the database resource. Currently, An Account Type / Account Status field is represented by what I believe it to be an enum value rather than a string. Ideally, it should be Account Status 0 = Closed and 1 = Open.
Is there a way to use a transformer to replace the enum values? I want to use a transformer so that I can save multiple queries into the query library which will enable immediate translation for all of the tables in the database WITHOUT mapping values on a table manually each time. Please let me know if anyone can help. Thanks!