Dynamic Query | BestHub

Selected Java Interview Questions

Jun 6, 2023 · Backend Development

Comparing MyBatis‑Plus and Bean Searcher: Core Differences, Advanced Queries, and Practical Use Cases

This article compares MyBatis‑Plus and Bean Searcher, detailing their basic differences, dynamic query capabilities, logical grouping, multi‑table joins, performance benchmarks, supported databases, and recommended usage scenarios, while providing extensive code examples and best‑practice recommendations for backend developers.

Bean SearcherDynamic QueryMyBatis-Plus

0 likes · 17 min read

Comparing MyBatis‑Plus and Bean Searcher: Core Differences, Advanced Queries, and Practical Use Cases

Top Architect

Jun 1, 2022 · Backend Development

Implementing Dynamic Queries with Spring Data Querydsl

This article explains how to use Spring Data Querydsl to parse and execute flexible, type‑safe dynamic queries, covering request definition, Google‑like and field‑specific query formats, integration with Spring repositories, predicate building, boolean expression handling, and challenges when querying nested collections.

Dynamic QueryPredicateQuerydsl

0 likes · 19 min read

Implementing Dynamic Queries with Spring Data Querydsl

macrozheng

Dec 16, 2021 · Backend Development

How to Build Complex Search APIs with Bean Searcher in One Line of Code

Learn how Bean Searcher enables Java backend developers to replace dozens of lines of ORM code with a single, flexible query method, supporting multi-table joins, dynamic filters, pagination, sorting, and custom operators, dramatically boosting development efficiency for complex list retrieval scenarios.

Bean SearcherDynamic QueryORM

0 likes · 17 min read

How to Build Complex Search APIs with Bean Searcher in One Line of Code

Top Architect

Mar 24, 2021 · Databases

Understanding the Use of WHERE 1=1 in Dynamic SQL

The article explains why developers insert the clause "WHERE 1=1" in dynamically generated SQL statements, shows example Java code, discusses how it prevents syntax errors when concatenating AND conditions, and offers advice on adding selective filters and indexes to avoid full table scans.

Database OptimizationDynamic QueryIndexing

0 likes · 3 min read

Understanding the Use of WHERE 1=1 in Dynamic SQL

Wukong Talks Architecture

Feb 1, 2020 · Backend Development

Advanced Query Techniques in MyBatis-Plus: Date Filtering, Subqueries, and Dynamic SQL with apply and inSql

This article demonstrates how to use MyBatis-Plus for complex queries—including date filtering, sub‑queries, INNER JOIN, dynamic SQL with the apply method, and the inSql helper—while highlighting potential SQL‑injection pitfalls and providing complete runnable code examples.

Dynamic QueryMyBatis-PlusSQL

0 likes · 6 min read

Advanced Query Techniques in MyBatis-Plus: Date Filtering, Subqueries, and Dynamic SQL with apply and inSql

Dada Group Technology

Jul 24, 2018 · Operations

Building a Scalable Growth Operations Platform: User Grouping, Dynamic Queries, and Automation

The article describes how a growth operations team can improve efficiency by designing a flexible user‑grouping system, dynamic query generation, and automated rule execution, while addressing data latency, real‑time processing, and scalability challenges through a Lambda‑style architecture.

Dynamic Queryautomationdata pipeline

0 likes · 14 min read

Building a Scalable Growth Operations Platform: User Grouping, Dynamic Queries, and Automation