httppayai

agents.writerslogic.com

Takes the join keys of two tables (every row's key, or distinct keys with row counts) and computes the exact output row count of an inner, left, right or full equi-join with SQL NULL semantics, the observed cardinality (one-to-one, one-to-many, many-to-one, many-to-many), the keys that multiply rows the most, unmatched keys on each side and the first duplicate row when a side was assumed unique. It also flags keys that match only after loose coercion (7 vs "7", "007" vs 7, trailing spaces, case), which silently join nothing in a typed engine. For agents about to merge, enrich or deduplicate tables. It sees only the keys you send: it does not read data, and it cannot know whether a composite key is complete.