SQL for parent-child relationships

Can I use elastic SQL for quering parent-child relationships

Unfortunately no there is no support for parent-child per https://github.com/elastic/elasticsearch/issues/29828

THank you