Tagged articles
JSqlParser
10 articles · Page 1 of 1
This article details a comprehensive governance framework for deploying Text-to-SQL systems in production, covering threat modeling, AST validation, multi-tenant isolation, performance admission via EXPLAIN, database permission hardening, budget-aware execution, cancellation semantics, and phased rollout strategies to ensure secure, auditable, and revocable data access.
AST ValidationEXPLAIN PlanJSqlParser
0 likes · 39 min read

This article details a production-ready dynamic data permission system using Spring Boot 3.x and MyBatis-Plus 3.5+, covering row-level interception via JSqlParser, column-level masking with Jackson serialization, RBAC+ABAC hybrid model, two-level caching with Caffeine and Redis, and lessons learned from handling complex JOINs, hot updates, and performance overhead.
ABACCaffeine CacheColumn-Level Masking
0 likes · 18 min read

This guide shows how to achieve multi‑tenant data isolation in a Spring Boot application by creating a MyBatis interceptor that modifies SQL statements using JSqlParser, covering dependency setup, interceptor implementation, testing, and the rationale for intercepting the StatementHandler.prepare method.
JSqlParserMyBatisSQL interceptor
0 likes · 14 min read

This article explains how to achieve data isolation in a Spring Boot application by creating a MyBatis interceptor that uses JSqlParser to parse and modify SQL statements at the prepare stage, covering tool introductions, dependency setup, interceptor code, testing examples, and the reasoning behind intercepting the prepare method.
JSqlParserMyBatisSQL interceptor
0 likes · 14 min read

This article explains how to achieve data isolation in a Spring Boot application by using a MyBatis interceptor that leverages JSqlParser to parse and modify SQL statements at the StatementHandler.prepare stage, covering tool introductions, dependency setup, interceptor implementation, testing examples, and the rationale behind intercepting the prepare method.
JSqlParserMyBatisSQL interceptor
0 likes · 13 min read

This article demonstrates how to achieve data isolation in a Spring Boot application by creating a MyBatis interceptor that modifies SQL statements using JSqlParser, covering tool introductions, dependency setup, interceptor implementation, testing for SELECT/INSERT/UPDATE/DELETE, and the rationale for intercepting the prepare method.
JSqlParserMyBatisSQL interceptor
0 likes · 14 min read

This article introduces the open‑source JSQLParser library, shows how to set it up in a Spring Boot 3 project, and provides step‑by‑step code examples for simple parsing, extracting tables, retrieving WHERE clauses, building or modifying SQL statements, and handling parsing errors.
Code ExampleJSqlParserSQL
0 likes · 8 min read

This article explains how to implement dynamic database switching in MyBatis by intercepting and modifying SQL statements to prepend database names to table names, using JSqlParser and MyBatis interceptors.
Database SwitchingDecorator PatternDynamic SQL
0 likes · 6 min read

This article explains how to query multiple identical databases under a single data source by intercepting MyBatis SqlSource, using JSqlParser to prepend the appropriate database name to table references, and applying the decorator pattern for seamless dynamic database switching.
Dynamic Database SwitchingJSqlParserJava
0 likes · 6 min read

This article introduces JSqlParser, a Java library that parses SQL statements into object structures, demonstrates how to extract query components with sample code, lists supported databases, and highlights additional features like formatting and framework integration.
JSqlParserJavaSQL
0 likes · 3 min read
