feat(analytics): cross-object grouping via FK-expand + generateSql scope preview (#3654 residual 2 + capability)

feat(analytics): cross-object grouping via FK-expand + generateSql scope preview (#3654 residual 2 + capability) #9932