DOYToWin

This article explores refactoring dynamic query interfaces by encapsulating pagination and sorting logic into a reusable superclass PageQuery to generate the dynamic components of the SQL statements.

This article explores how to use query object instances to automatically generate dynamic query conditions. By abstracting query conditions into four types of fields—predicate suffix fields, logical suffix fields, subquery fields, and entity relationship fields—it achieves automatic construction of different kind of query conditions.

本文探讨了如何利用查询对象实例自动生成动态查询条件，通过将查询条件抽象为四种字段类型（谓词后缀字段、逻辑后缀字段、子查询字段和实体关系字段）以实现查询条件的自动构造。

Introduction

The dynamic queries is a long-standing pain point in ORM frameworks.
Solving this problem will have a profound impact on simplifying the interaction logic of the database and improving the maintainability of the code.
This article locates a structural duplication in dynamic queries and proposes a general reconstruction method to optimize the code related to dynamic queries.

介绍

动态查询问题是ORM框架中一个长期存在的痛点。
解决这个问题将对简化数据库的交互逻辑和提高代码的可维护性产生深远影响。
本文定位了动态查询中的一种结构型重复，并提出了一种通用的重构方法，以优化动态查询相关的代码。

This is all thanks to the support of OQM (Object Query-Language Mapping) technology, we developed a Go version called GoooQo.

Object/Relational Mapping (ORM) may lead the development of object-oriented applications based on relational databases in the wrong direction.

对象/关系映射（ORM）技术在一定程度上将基于关系数据库的应用开发引向了错误的方向。一个好的技术方案应该是把事情变得越来越简单，而不是越来越复杂。