const sq = db.$with('sq').as(db.select({
  ...getTableColumns(apartments),
  distance: sql`111.320 * COS(${apartments.long} - 56.17058131394731) * ABS(${apartments.long} - 56.17058131394731) + 110.574 * ABS(${apartments.lat} - 10.18838401351414)`.mapWith(Number).as("distance")
}).from(apartments))
const res = await db.with(sq).select().from(sq).where(lte(sq.distance, 10))

const sq = db.$with('sq').as(db.select({
  ...getTableColumns(apartments),
  distance: sql`111.320 * COS(${apartments.long} - 56.17058131394731) * ABS(${apartments.long} - 56.17058131394731) + 110.574 * ABS(${apartments.lat} - 10.18838401351414)`.mapWith(Number).as("distance")
}).from(apartments))
const res = await db.with(sq).select().from(sq).where(lte(sq.distance, 10))

select "id", "name", "lat", "long", 111.320 * COS("long" - 56.17058131394731) * ABS("long" - 56.17058131394731) + 110.574 * ABS("lat" - 10.18838401351414) from "apartments" where distance < 10

select "id", "name", "lat", "long", 111.320 * COS("long" - 56.17058131394731) * ABS("long" - 56.17058131394731) + 110.574 * ABS("lat" - 10.18838401351414) from "apartments" where distance < 10

PostgresError: column "distance" does not exist

PostgresError: column "distance" does not exist

select "id", "name", "lat", "long", 111.320 * COS("long" - 56.17058131394731) * ABS("long" - 56.17058131394731) + 110.574 * ABS("lat" - 10.18838401351414) as "distance" from "apartments" where distance < 10

select "id", "name", "lat", "long", 111.320 * COS("long" - 56.17058131394731) * ABS("long" - 56.17058131394731) + 110.574 * ABS("lat" - 10.18838401351414) as "distance" from "apartments" where distance < 10

const res = await db.select({.....

const res = await db.select({.....

export const db = drizzle(queryClient, { schema, logger: true });

export const db = drizzle(queryClient, { schema, logger: true });