Monthly Update - 2025-12

A packed month with significant new features: Redis is now optional, RawSQL property support, request pagination, aggregation function improvements, and SQLite bug fixes.

Changes

teaql-spring-boot-starter

🚀 Make Redis optional in autoconfig module

Redis is no longer a required dependency for TeaQL. If Redis is not available on the classpath, TeaQL will fall back to a LocalLockService for locking operations. This makes TeaQL easier to use in development and simpler deployments.

+ Redis is now an optional dependency
+ LocalLockService: in-memory lock implementation for non-Redis environments
+ RedisLockService: Redis-based distributed lock (when Redis is available)
+ TQLAutoConfiguration: conditionally loads lock service based on classpath

Before: Required spring-boot-starter-data-redis as a mandatory dependency.

After: Works without Redis. If Redis is on the classpath, distributed locking is used automatically. Otherwise, falls back to local locking.

This is particularly useful for:

• Local development without Redis
• Single-instance deployments
• Testing environments

🔧 Fix SQLite issue

Fixed a SQLite-specific bug in schema management. The SQLRepository was not correctly handling certain SQLite-specific SQL syntax, which could cause schema ensure operations to fail.

+ SQLRepository: added SQLite-specific SQL handling
+ SQLiteRepository: 61 lines of fixes for schema operations
+ DynamicSearchHelper: adjusted for SQLite compatibility

🚀 Add RawSQL support for property

Properties can now use RawSQL expressions. This allows you to define computed or database-native expressions as property values, giving you full control over the SQL that gets generated for specific fields.

+ Property-level RawSQL support
+ Allows defining custom SQL expressions for individual properties

Example:

// Use RawSQL for a computed property
@RawSQL("CONCAT(first_name, ' ', last_name)")
String getFullName();

🚀 Add prefix to aggregation functions

Aggregation functions (count, sum, avg, min, max) now include a configurable prefix in the result column name, preventing naming collisions when multiple aggregations are used in the same query.

+ Configurable prefix for aggregation function result columns
+ Prevents column name conflicts in multi-aggregation queries

🔧 Add configuration in embedded mode

Added configuration support for TeaQL when running in embedded database mode (H2, SQLite in-memory). This ensures all TeaQL features work correctly even with embedded databases.

🚀 Upgrade to version 1.84

Version bump to 1.84, incorporating all the fixes and features from this cycle.

teaql-code-gen

🚀 Add pagination support in request

Request objects now include pagination parameters (page, pageSize). This means generated search requests automatically support paginated queries without additional configuration.

+ Added page and pageSize fields to generated Request classes
+ Simplifies pagination for all list/search endpoints

🚀 Improve readability of aggregation function results

Aggregation function result fields now have more readable naming. Instead of cryptic auto-generated names, the results use clear, descriptive aliases.

+ Aggregation results use human-readable column aliases
+ Improved developer experience when working with aggregate queries

🚀 Add RawSQL for property; fix parent filter issue for inherit items

Aligned with the starter's RawSQL support, the code generator now correctly generates property-level RawSQL expressions. Also fixed a bug where parent-level filters were not correctly applied to inherited items in queries.

+ Code generation support for property-level RawSQL
+ Fixed: parent filters now correctly propagate to inherited child entities

🚀 Fix model view links issue

Fixed broken links in the generated model view documentation. Cross-references between entities in the HTML model viewer were pointing to incorrect paths.

🔧 Fix spell known

Corrected a typo in the code generation templates.

🚀 Upgrade Spring Boot version

Updated the code generator's Spring Boot template to use the latest compatible Spring Boot version, ensuring generated projects start with up-to-date dependencies.

🚀 Upgrade version

Version bump for the code generator package.

RawSQL Deep Dive

RawSQL support in TeaQL allows you to bypass the query builder for specific properties or criteria. There are three levels:

1. Property-level RawSQL (new): Define custom SQL expressions for computed properties
2. Criteria-level RawSQL: Use raw SQL in WHERE clauses
3. Select-level RawSQL: Custom SQL in SELECT projections

All three levels are now supported across both the starter and code generator.