I often need to work in a database on the command line. Booleans are not displayed in an intuitive way. I mean this: There is a simple trick that helps me to read it much better: cast it to an integer. This is done by adding +0 to the boolean column: