>> They call the DB "relational" but I can't seem to find anything in the docs about relations, joins, cascade delete, etc.

Looks like they support table relationships via PK-FK (mentioned under Data Type section: https://catalyst.zoho.com/help/data-store.html#Column_Charac...), but there's no mention of querying or inserting relational data.