export const projects = pgTable('Projects', {
    project: text("project").notNull().primaryKey(),
    backgroundImageUuid: text('background_image_uuid'),
    siteId: text("site_id").notNull().primaryKey(),
    systemId: text("system_id").notNull().primaryKey(),
});

const result3 = await db(env)
    .select({
      projects.project,
      projects.backgroundImageUuid
    })
    .from(projects)
    .where(
      and(
        eq(projects.siteId, data.siteId),
        eq(projects.systemId, siteConfig.systemId)
      )
    );

Type 'PgTableWithColumns<{ name: "Projects"; schema: undefined; columns: { project: PgColumn<{ name: "project"; tableName: "Projects"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; enumValues: [...]; baseColumn: never; }, {}, {}>; backgroundImageUuid: PgColu...' is not assignable to type 'SQL<unknown> | Aliased<unknown> | MySqlColumn<ColumnBaseConfig<ColumnDataType, string>, object> | MySqlTable<TableConfig> | SelectedFieldsFlat<...>'.
  Type 'PgTableWithColumns<{ name: "Projects"; schema: undefined; columns: { project: PgColumn<{ name: "project"; tableName: "Projects"; dataType: "string"; columnType: "PgText"; data: string; driverParam: string; notNull: true; hasDefault: false; enumValues: [...]; baseColumn: never; }, {}, {}>; backgroundImageUuid: PgColu...' is not assignable to type 'SelectedFieldsFlat...