Better Derivation Support

Problem Statement

When linking concepts via transformations, the current syntax is cumbersome.

eg

key country string;
key unknown_casing_country string;
auto _upper_unknown_country <- upper(unknown_casing_country);
merge _upper_unknown_counter into country;

Proposed Solution

Specific shorthand could be added for this, which would save one line.

key unknown_casing_country_string;
derive country <- upper(unknown_casing_country)

We can also consider automatically adding scalar derived concepts to datasources when all inputs are present on the datasource, to avoid users needing to explicitly bind; discovery off datasources is faster than traversing the synonym tree.

Alternatives Considered

Please briefly describe which alternatives, if any, have been considered, including merits of alternate approaches and
tradeoffs being made.

Additional Context

Please provide any other information that may be relevant.

The issue names no files, tests, or entry points. Start by tracing the existing transformation-linking syntax and derivation handling, then determine how the proposed shorthand and automatic datasource binding should interact. Done means the behavior is specified, implemented, and covered for the examples and edge cases described.