Type ORM

We can drop slow query to avoid crashing the server.

You can provide a certain index for database server to use in some cases. This feature is only supported in MySQL.

You can join not only relations, but also other unrelated entities or tables. Examples:

 Inner and left joins If you want to use INNER JOIN instead of LEFT JOIN just use innerJoinAndSelect instead: This will generate: The difference between LEFT JOIN and INNER JOIN is that INNER JOIN won’t return a user if it does not have any photos. LEFT JOIN will return you the user even if it doesn’t have photos. Join without selection You can join data without its selection. To…

This will generate following SQL query: You can also add conditions to the join expression instead of using “where”: This will generate the following SQL query:

Adding an SQL OFFSET expression is easy as: Which will produce the following SQL query: The resulting SQL query depends on the type of database (SQL, mySQL, Postgres, etc). Note: OFFSET may not work as you may expect if you are using complex queries with joins or subqueries. If you are using pagination, it’s recommended to use skip instead.

Adding a LIMIT expression is easy as: Which will produce the following SQL query: The resulting SQL query depends on the type of database (SQL, mySQL, Postgres, etc). Note: LIMIT may not work as you may expect if you are using complex queries with joins or subqueries. If you are using pagination, it’s recommended to use take instead.

Adding GROUP BY expression Adding a GROUP BY expression is easy as: Which will produce the following SQL query: To add more group-by criteria use addGroupBy: If you use .groupBy more than once you’ll override all previous GROUP BY expressions.

Adding an ORDER BY expression is easy as: Which will produce: You can change the ordering direction from ascending to descending (or versa): You can add multiple order-by criteria: You can also use a map of order-by fields: If you use .orderBy more than once you’ll override all previous ORDER BY expressions. Adding ORDER BY expression Adding an ORDER BY expression is easy as: Which…

Adding HAVING expression Adding a HAVING expression is easy as: Which will produce following SQL query: You can add AND into an exist HAVING expression: Which will produce the following SQL query: You can add OR into a exist HAVING expression: Which will produce the following SQL query: You can combine as many AND and OR expressions as you need. If you use .having more than once you’ll override all previous HAVING expressions.