@Emile S So, NaviCat returns Integer for Boolean and this is (more or less) right or wrong: it depends of your point of view.
Give us a different bug, this one is not one
No, you have it backwards. The column in sqlite is an integer, but Xojo is reporting it as a boolean. Xojo has the bug, not Navicat (nor any of several other sqlite utilities out there).
And if you had bothered to really read the Feedback case, you would see that it's not just integers to booleans, but doubles are reported as Time! Plus many other problems as pointed out in the feedback case. The db editor (and other sqlite interfaces) in Xojo is completely broken, and Xojo doesn't care enough about it because they probably don't ever use it.
Xojo (Geoff) keeps harping about how they want Xojo to be the choice development system for novices and hobbyists, yet they have no idea what these people need. A novice/hobbyist probably has no experience with databases, so their only interaction with one will be with Xojo's broken db editor. They wouldn't know not to use Xojo's db editor but should instead find a capable sqlite editor from elsewhere. When they do look elsewhere, it will probably be for another development system that works correctly, abandoning Xojo completely.
Tomas is correct, Xojo would do better to just remove the db editor instead of leaving it in its current broken state. Otherwise, it will do more harm than good to their "target audience" marketing.