Are `multiple joins` same as SQL multiple joins ?

loader: async ({ params }) => {
    const { id } = params;
    // main table
    const player = createPlayers(id);
    // other tables
    const qualification = createResults(id, "qualification");
    const institute = createResults(id, "institute");
    const area = createResults(id, "area");
    const national = createResults(id, "national");
    // live collection with joins
    const collection = createLiveQueryCollection((q) => {
      return q
        .from({ p: player })
        .leftJoin({ qualification }, ({ p, qualification }) => eq(p.id, qualification.id))
        .leftJoin({ institute }, ({ p, institute }) => eq(p.id, institute.id))
        .leftJoin({ area }, ({ p, area }) => eq(p.id, area.id))
        .leftJoin({ national }, ({ p, national }) => eq(p.id, national.id))
        .select(({ p, qualification, institute, area, national }) => ({
          id: p.id,
          category: p.category,
          qualification,
          institute,
          area,
          national,
        }));
    });

SELECT
  player.id AS player_id,
  player.category AS player_category,
  "result-qualification".score AS qualification_score,
  "result-area".score AS area_score,
  "result-national".score AS national_score  
FROM player
LEFT JOIN "result-qualification" ON player.id = "result-qualification".id
LEFT JOIN "result-institute" ON player.id = "result-institute".id
LEFT JOIN "result-area" ON player.id = "result-area".id
LEFT JOIN "result-national" ON player.id = "result-national".id