Wordpress WP_List_Table help

How to substitute a number with a specific string when populating a custom WP_List_Table in admin area?

The data from the SQL select could be a number like 0 or 1. I would show "Close" or "Open" in the table instead of the numbers,

Should I do it at SQL select level or at Wordpress level? Thanks

 

Something like this might work, modify this to suit your specific query:

SELECT ID, field1,
CASE
WHEN field1 > 0 THEN "open"
ELSE "closed"
END
FROM table where condition order by ID desc limit 10;