mybatis-flex/mybatis-flex
Mybatis Flex
MyBatis-Flex is an object-relational mapping framework for Java that extends MyBatis with a fluent API and automated CRUD operations. It provides a data access suite featuring an automatic CRUD data mapper, a type-safe SQL query builder, and a row-based query engine for manipulating records without predefined entity classes.
The framework includes a multi-dialect SQL translator that converts generated syntax across different database engines, such as MySQL, PostgreSQL, and Oracle. It further distinguishes itself by offering annotation-free entity mapping using runtime reflection and naming conventions, alongside configurable strategies for automatic primary key generation.
The library covers broad capability areas including type-safe query construction with support for joins and subqueries, dynamic database result paging, and lightweight data access abstractions to reduce boilerplate code.
Features
- Fluent Query Construction - Offers a chainable, object-oriented fluent API for the programmatic construction of SQL statements.
- ORM Frameworks - Extends MyBatis with a fluent API and automated CRUD operations for object-relational mapping.
- SQL Query Builders - Provides a programmatic way to build complex SQL queries with joins and subqueries.
- Object-to-Row Mapping - Simplifies data access by mapping database rows directly to Java objects for retrieval and modification.
- Database Dialect Adapters - Translates generic database logic into engine-specific syntax for MySQL, PostgreSQL, and Oracle.
- Entity CRUD Management - Provides a data access layer for standard CRUD operations on entity classes with automatic key generation.
- Type-Safe Query Construction - Ships a type-safe SQL builder providing compile-time autocompletion for complex joins, grouping, and subqueries.
- Fluent Query Builders - Offers a type-safe, chainable API for constructing complex SQL queries.
- Query Condition Builders - Provides a fluent API for constructing complex SQL WHERE clauses and dynamic filtering criteria.
- SQL CRUD Operations - Simplifies standard create, read, update, and delete operations on relational tables.
- SQL Dialect Adapters - Translates generated SQL into engine-specific syntax using pluggable dialect adapters at runtime.
- Reflection-Based Mappings - Implements annotation-free entity mapping by using runtime reflection and naming conventions to link Java objects to database tables.
- Type-Safe Query Builders - Ensures SQL validity and provides compile-time autocompletion for joins and filters.
- Object Mapping - Maps database tables to Java objects using runtime reflection and naming conventions.
- Database Pagination Adapters - Implementing offset and limit logic for large datasets using a standardized adapter that works across different database systems.
- Row-Based Query Interfaces - Provides a flexible interface to query and manipulate records using key-value mappings instead of entity classes.
- Dynamic Row Mapping - Enables database operations using a flexible Row object instead of predefined entity classes.
- Automatic Primary Key Injection - Provides automatic generation and insertion of primary keys using configurable strategies like auto-increment or sequences.
- Key Generation Strategies - Implements configurable strategies for automatic primary key generation.
- Entity-Free Querying - Allows manipulating database records via flexible row mapping when entity classes are not desired.
- Pagination - Wraps query results with metadata and rewrites SQL to include dialect-specific pagination.
- Raw Query Interfaces - Provides a row-based query engine to manipulate database records without requiring predefined entity classes.
- Dialect Transformers - Rewrites SQL queries to apply database-specific pagination syntax based on the active dialect.
