limiting a join when filtering by an extra field.

 const sq = db
    .select({
      ...getTableColumns(placeDetailsTable),
      distance: sql<number>`.....`.as("distance"),
    })
    .from(placeDetailsTable)
    .as("subquery");

  const query = await db
    .select()
    .from(sq)
    .where(
      and(lt(sq.distance, maxDistanceInKm), eq(postingsTable.isActive, true)),
    )
    .orderBy(sq.distance)
    .innerJoin(propertiesTable, eq(sq.id, propertiesTable.placeId))
    .innerJoin(
      postingsTable,
      eq(propertiesTable.publicFacingId, postingsTable.propertyPublicId),
    );

{ with: { images: { limit: 5 } } }