Iinkqubo zolawulo lwedathabheyisi yolwalamano ezisekelwe kwi-SQL zifanelekile kancinci kwimibuzo ehambelanayo okanye ephindaphindayo. Ezinye iinkqubo ezifana ne -ArangoDB zifanelekile ngakumbi koku (bekukho intetho entle malunga noku kwi -GOTO 2016 ). Nangona kunjalo, kunokwenzeka ukwenza imibuzo ephindaphindayo kwi-SQL usebenzisa i-Common Table Expressions , ekuvumela, umzekelo, ukuba ubuze iitafile zomzali/zomntwana zakudala kubo bonke ookhokho kunye nezizukulwana.
KwiPostgreSQL kujongeka njengoku, umzekelo:
0672c4761d202a35a9059fa137ace7c3
Ukuba ufuna ukufumana bonke abantwana bento ethile_id, usebenzisa iZichazi eTafileni eliqhelekileyo:
0672c4761d202a35a9059fa137ace7c3
Ukumisa abazali akukho ngxaki:
0672c4761d202a35a9059fa137ace7c3