@mikro-orm/sql - npm Package Compare versions

Comparing version 7.1.6-dev.15 to 7.1.6-dev.16

package.json

 {
   "name": "@mikro-orm/sql",
-  "version": "7.1.6-dev.15",
+  "version": "7.1.6-dev.16",
   "description": "TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, PostgreSQL and SQLite databases as well as usage with vanilla JavaScript.",
@@ -50,3 +50,3 @@ "keywords": [
   "dependencies": {
-    "kysely": "0.29.2"
+    "kysely": "0.29.3"
   },
@@ -57,3 +57,3 @@ "devDependencies": {
   "peerDependencies": {
-    "@mikro-orm/core": "7.1.6-dev.15"
+    "@mikro-orm/core": "7.1.6-dev.16"
   },
@@ -60,0 +60,0 @@ "engines": {

query/QueryBuilder.d.ts

@@ -985,2 +985,18 @@ import { type AbortQueryOptions, type AnyEntity, type AutoPath, type Collection, type ConnectionType, type Dictionary, type EntityData, type EntityDTOFlat, type EntityDTOProp, type EntityKey, type EntityManager, EntityMetadata, type EntityName, type EntityProperty, type ExpandProperty, type FilterObject, type FilterOptions, type FilterValue, type FlushMode, type GroupOperator, type Loaded, LockMode, type LoggingOptions, type MetadataStorage, type PrimaryProperty, type ObjectQuery, PopulateHint, type PopulateOptions, type PopulatePath, QueryFlag, type QueryOrderKeysFlat, type QueryOrderMap, type QueryResult, RawQueryFragment, type Raw, type RequiredEntityData, type Scalar, type SerializeDTO, type Subquery, type Transaction } from '@mikro-orm/core';
     private hasToManyJoins;
+    /**
+     * Resolves a `persist: false` virtual field referenced in `orderBy` (e.g. `qb.as('reviewCount')` or a
+     * `raw()` fragment aliased in the select) to the alias and SQL expression it was selected under. The
+     * alias is used to order the outer query; the raw expression is inlined into `min(...)` inside the
+     * pagination sub-query, where dialects like PostgreSQL cannot reference a select alias.
+     */
+    protected resolveVirtualField(propName: string, fieldName: string): {
+        alias: string;
+        expr: string;
+    } | undefined;
+    /**
+     * Rewrites `orderBy` keys that reference a `persist: false` virtual field selected via `qb.as(alias)` so
+     * they point at the actual select alias. The mapper would otherwise resolve such a key to the property's
+     * naming-strategy column name, which does not exist when the alias literal differs (e.g. `reviewCount`).
+     */
+    private rewriteVirtualFieldOrderBy;
     protected wrapPaginateSubQuery(meta: EntityMetadata): void;
@@ -987,0 +1003,0 @@ /**

New alerts

URL strings

Supply chain risk

Package contains fragments of external URLs or IP addresses, which the package may be accessing at runtime.

Fixed alerts

URL strings

Supply chain risk

Package contains fragments of external URLs or IP addresses, which the package may be accessing at runtime.

Improved metrics

Total package byte prevSize

1054954

0.42%

Lines of code

22047

0.29%

Dependency changes

• + Added

  @mikro-orm/core@7.1.6-dev.16
  (transitive)

• + Added

  kysely@0.29.3
  (transitive)

• - Removed

  @mikro-orm/core@7.1.6-dev.15
  (transitive)

• - Removed

  kysely@0.29.2
  (transitive)

• Updated

  kysely@0.29.3