VSCode Intellisense Error: "Type 'PgTableWithColumns... is not assignable to type 'SQL<unknown>..."
Hey, im new to Drizzle and am encountering this intelliselse error on VSCode. Notably the code runs fine.
I am using Planetscale and Cloudflare Pages Functions.
Thank you in advance!
I am using Planetscale and Cloudflare Pages Functions.
Thank you in advance!
Schema
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(),
});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(),
});Query
const result3 = await db(env)
.select({
projects.project,
projects.backgroundImageUuid
})
.from(projects)
.where(
and(
eq(projects.siteId, data.siteId),
eq(projects.systemId, siteConfig.systemId)
)
);const result3 = await db(env)
.select({
projects.project,
projects.backgroundImageUuid
})
.from(projects)
.where(
and(
eq(projects.siteId, data.siteId),
eq(projects.systemId, siteConfig.systemId)
)
);Error
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...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...
