Typescript support in V2 with reading foreign tables

import { useQuery } from '@tanstack/react-query';

import supabase from './supabase';
import { Listing } from './types';

export async function getListings() {
  const query = `
    id,
    title,
    price,
    photos,
    seller: profiles (id, name, city, state),
    categories (name, slug)
  `;

  return supabase.from<Listing>('listings').select(query);
}

export const useGetListings = () => {
  return useQuery(['home', 'listings'], () => getListings());
};

import { useQuery } from '@tanstack/react-query';

import supabase from './supabase';
import type { Database } from './database.types';

export async function getListings() {
  const response = await supabase.from('listings').select(`
    id,
    title,
    price,
    photos,
    seller: profiles (id, name, city, state),
    categories (name, slug)
  `);

  return response;
}

export const useGetListings = () => {
  return useQuery(['home', 'listings'], () => getListings());
};

type profiles = Database['public']['Tables']['profiles']['Row'];
type ListingsResponse = Awaited<ReturnType<typeof getListings>>;
export type ListingsResponseSuccess = ListingsResponse['data'] & {
  seller: profiles;
};