For GDAL data formats with embedded relationship information, whenever a table is added QGIS is now able to discover relationships and immediately add all the related tables to the current project (if they don't already exist). Additionally, when adding these related layers QGIS will automatically configure the corresponding QGIS relationships.
This works for all formats which support the GDAL relationship API, which include: