[BUG]:Support update with subqueries

[zoriya]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

v0.39.0

What version of drizzle-kit are you using?

0.30.4

Other packages

No response

Describe the Bug

An update statement can't have subqueries without workarounds.

example:

await db
	.update(shows)
	.set({
		availableCount: sql`${db
			.select({ count: count() })
			.from(entries)}`,
	})

(note the extra sql`${ before the subquery)

i'd expect to be able to do that:

await db
	.update(shows)
	.set({
		availableCount: db
			.select({ count: count() })
			.from(entries),
	})

I found this workaround here.