📄️ Query Conditions
When you want to make complex queries, you can easily end up with a lot of boilerplate code full of curly brackets:
📄️ Populating relations
MikroORM is capable of loading large nested structures while maintaining good performance, querying each database table only once. Imagine you have this nested structure:
📄️ Loading Strategies
MikroORM supports three loading strategies:
📄️ Filters
MikroORM has the ability to pre-define filter criteria and attach those filters to given entities. The application can then decide at runtime whether certain filters should be enabled and what their parameter values should be. Filters can be used like database views, but they are parameterized inside the application.
📄️ Query Builder
To have access to createQueryBuilder() method, you need to import EntityManager from your driver package.
📄️ Using raw SQL query fragments
raw() helper
📄️ Kysely
MikroORM provides first-class integration with Kysely, a type-safe SQL query builder. Through this integration, you can get a configured Kysely instance directly from EntityManager, leveraging MikroORM's metadata to drive Kysely's query transformation and type inference.