RawSQL Queries and Model Visualization
· One min read
Full RawSQL support plus a suite of model visualization tools.
RawSQL Three-Level Support
// WHERE clause
Q.orders().filter(
RawSqlCriteria.of("EXTRACT(YEAR FROM create_time) = 2025")
).executeForList(ctx);
+ RawSQL in search criteria (WHERE)
+ RawSQL in select projections
+ RawSQL in criteria expressions
Data Design Documentation Generator
Generates Markdown documentation from domain models, including ER diagrams, field descriptions, and relationship docs.
HTML Model Browser
A searchable, interactive domain model browser:
+ HTML model viewer: interactive domain model browser
+ Searchable entity list
+ Relationship visualization
+ Table relation count display
Word Cloud Visualization
Domain model word cloud with concept sizing based on entity importance.
Other Improvements
- Optimized error reporting (line numbers, original SQL, parameter values)
startsWith/endsWithnaming fixgt/ltoperators restricted to numeric types
