/**
 * sql.helpers.ts
 *
 * Helpers that wrap common use cases for the `sql` template literal from [sql.ts](./sql.ts)
 */
import { ArrayElement, Query, SqlDatabase, SqlInterface } from './sql.types';
/**
 * Return the first element, after the query is run, returns undefined if result is empty
 *
 * ```typescript
 * const showSql = sql<ShowSqlQuery>`
 *   SELECT id, name
 *   FROM table1
 *   WHERE id = $id
 * `;
 * const showQuery = maybeOneResult(showSql);
 *
 * const myRowItem = await showQuery(db, { id: 12 });
 * ```
 */
export declare const maybeOneResult: <TQueryInterface extends SqlInterface<unknown[]>>(query: Query<TQueryInterface, TQueryInterface["result"]>) => Query<SqlInterface<ArrayElement<TQueryInterface["result"]> | undefined>, TQueryInterface["result"]>;
/**
 * Return the first element, useful for queries where we always expect at least one result
 *
 * @throws PotygenRuntimeError if row is empty
 *
 * ```typescript
 * const showSql = sql<ShowSqlQuery>`
 *   INSERT (name)
 *   INTO table1
 *   VALUES ($name)
 *   RETURNING id, name
 * `;
 * const showQuery = oneResult(showSql);
 *
 * const myRowItem = await showQuery(db, { name: 'myNewRow' });
 *
 * ```
 */
export declare const oneResult: <TQueryInterface extends SqlInterface<unknown[]>>(query: Query<TQueryInterface, TQueryInterface["result"]>) => Query<SqlInterface<ArrayElement<TQueryInterface["result"]>>, TQueryInterface["result"]>;
/**
 * Return the rows but throw an error if no rows have been returned
 *
 * @throws PotygenRuntimeError if row is empty
 *
 * ```typescript
 * const showSql = sql<ShowSqlQuery>`
 *   INSERT (name)
 *   INTO table1
 *   VALUES ($name)
 *   RETURNING id, name
 * `;
 * const showQuery = atLeastOneResult(showSql);
 *
 * const myRowItem = await showQuery(db, { name: 'myNewRow' });
 *
 * ```
 */
export declare const atLeastOneResult: <TQueryInterface extends SqlInterface<unknown[]>>(query: Query<TQueryInterface, TQueryInterface["result"]>) => Query<SqlInterface<TQueryInterface["result"]>, TQueryInterface["result"]>;
/**
 * Return the first element, useful for queries where we always expect at least one result
 *
 * @throws PotygenRuntimeError if row is empty
 *
 * ```typescript
 * const showSql = sql<ShowSqlQuery>`
 *   SELECT id, name
 *   FROM table1
 *   WHERE id = $id
 * `;
 * const idsQuery = map((rows) => rows.map(({ id }) => id)), showSql);
 *
 * const ids = await showQuery(db, { name: 'myNewRow' });
 *
 * ```
 */
export declare const mapResult: <TMappedResult, TSqlInterface extends SqlInterface<unknown> = SqlInterface<unknown>, TOriginalResult = TSqlInterface["result"]>(mapper: (rows: TSqlInterface["result"], db: SqlDatabase, params: TSqlInterface["params"]) => TMappedResult, query: Query<TSqlInterface, TOriginalResult>) => Query<SqlInterface<TMappedResult>, TSqlInterface["result"]>;