Greg WilsonI have now rewritten two projects to use the PyPika query builder (https://pypika.readthedocs.io/) instead of an object-relational mapper, and the query builder approach had many fewer WTF moments. Caveat: they are small projects with relatively simple data models (a dozen to a couple of dozen tables, no need for recursive queries) and I haven't had to maintain the code through schema changes yet.
powersoffourGNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.