Method getSingleResult

packages/sql/src/query/QueryBuilder.ts:2651–2658

* Executes the query, returning the first result or null

()

   * Executes the query, returning the first result or null
   */
  async getSingleResult(): Promise<Loaded<Entity, Hint, Fields> | null> {
    if (!this.#state.finalized) {
      this.limit(1);
    }

    const [res] = await this.getResultList(1);
    return res || null;
  }

  /**
   * Executes count query (without offset and limit), returning total count of results