Function getJsonIndexDefinition

packages/sql/src/AbstractSqlPlatform.ts:133–142

(index: IndexDef)

  }

  override getJsonIndexDefinition(index: IndexDef): string[] {
    return index.columnNames.map(column => {
      if (!column.includes('.')) {
        return column;
      }

      const [root, ...path] = column.split('.');
      return `(json_extract(${root}, '$.${path.join('.')}'))`;
    });
  }

  override supportsUnionWhere(): boolean {
    return true;