ebuilder-sql-query-result-shaping

name	ebuilder-sql-query-result-shaping
description	Result shaping playbook for query-* definitions in configs/sql.*.yml. USE FOR: propType, hideProps, customProps, output aliasing, and responseTypeErrors. DO NOT USE FOR: pre/post step orchestration internals.

eBuilder Query Result Shaping

Purpose

Use this skill to shape final query output contracts.

Scope

• propType for output typing.
• hideProps to hide or rename fields.
• customProps to compute additional fields.
• responseTypeErrors to customize cardinality-failure responses.

Output Typing

Allowed propType values:

• string, bool, int, double, long, decimal, json

Prefer SQL aliases (AS "camelCase") and map those exact keys in propType.

Sensitive Data Controls

Use hideProps to suppress internal fields (for example password hashes) or alias them.

Result Contract Errors

For strict response types (for example single), use responseTypeErrors to map:

• notFound
• moreThanOne

Example

query:
  query-user-profile:
    datasource: main
    responseType: singleOrNull
    command: |
      SELECT id AS "id", email AS "email", password_hash AS "passwordHash"
      FROM users
      WHERE id = ${userId}
    propType:
      id: int
      email: string
    hideProps:
      passwordHash: true

Deterministic Checks

1. propType keys match final output keys.
2. Hidden fields are not required by downstream consumers.
3. Sensitive fields are removed before output.
4. customProps dependencies are available in scope.
5. responseTypeErrors is set when strict cardinality needs custom responses.