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.

mybatis-flexmybatis-flex

Features

Star history