Function getSearchJsonPropertyKey

packages/sql/src/AbstractSqlPlatform.ts:103–117

(
    path: string[],
    type: string,
    aliased: boolean,
    value?: unknown,
  )

  }

  override getSearchJsonPropertyKey(
    path: string[],
    type: string,
    aliased: boolean,
    value?: unknown,
  ): string | RawQueryFragment {
    const [a, ...b] = path;
    const jsonPath = this.quoteValue(`$.${b.map(this.quoteJsonKey).join('.')}`);

    if (aliased) {
      return raw(alias => `json_extract(${this.quoteIdentifier(`${alias}.${a}`)}, ${jsonPath})`);
    }

    return raw(`json_extract(${this.quoteIdentifier(a)}, ${jsonPath})`);
  }

  /**
   * Quotes a key for use inside a JSON path expression (e.g. `$.key`).