Help with foreign keys and postgres-kt

[lmick002]

Im having a slight issue using Postgres-kt. When I run a query with foreign keys, the data returned doesn't connect the relational data from the tables queried. This query worked for the supabase-js library but I haven't been able to get the right data from the postgres-kt library.

Here's my query:

const { data: profile, error } = await db.from("profiles")
.select(
*, tools: tools_user_id_fkey(*), shops: shops_user_id_fkey(*) )
.eq('id', id)
.is('deleted_at', null)
.single();