19 Aug 2015 Therefore, you should already know how to write a simple join query and basic CRUD queries; . Now that we've understood this trick, here is my pseudocode of the merge sort. Each column stores a certain type of data (integer, string, date …). .. It's “easy” to read because SQLite uses simple rules.