resolve_join
Read-onlyIdempotent
Get the canonical SQL JOIN clause between two named entities. Returns a ready-to-paste clause with column mapping, eliminating manual join writing.
Instructions
Use this when you have two entity names and need the canonical SQL join between them. Returns a ready-to-paste JOIN clause with column mapping. Use suggest_joins instead when you only have physical table names. Don't use when you need to discover what entities exist — call list_entities first.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entity_a | Yes | The first entity to join, by name (e.g. `customer`). Order doesn't matter — `resolve_join` is direction-insensitive; the response preserves the direction the join was originally confirmed in. | |
| entity_b | Yes | The second entity to join, by name (e.g. `order`). Both entities must exist; call `list_entities` if unsure. | |
| name | No | When 2+ canonical joins exist between the entity pair (billing vs shipping address, primary vs secondary user, etc.), pass the canonical-join name to disambiguate. Leave null to receive an ambiguity-refusal response listing the available names. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| status | Yes | ||
| data | No | ||
| error | No | ||
| confidence | No | ||
| provenance | No | ||
| follow_up_hints | No | ||
| degradation_reason | No | ||
| charter_version | No | 1.2 |