DOYToWin

The designers and developers of ORMs have never truly understood the real problems they need to address. Once this problem is solved, the ORM will no longer be an ORM.

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.

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