SQL-like join in Synapse

Description

The Vanderbilt CSBC site has requested that Synapse support SQL-like join functionality.

If it does, I don't see it documented here:
https://sagebionetworks.jira.com/wiki/spaces/PLFM/pages/3571998/Repository+Service+API#RepositoryServiceAPI-QueryAPI

A workaround was suggested here and ultimately rejected as too much work:
https://sagebionetworks.jira.com/browse/PLFM-3069?jql=summary%20~%20%22join%22

Environment

None

Assignee

Meredith Slota

Reporter

Brian White

Labels

None

Validator

Brian White

Development Area

None

Release Version History

None

Components

Sprint

None

Priority

Minor
Configure