DT
Drizzle Team•15mo ago
tacomanator

Alias in from() change? (SQLite)

Did something change wrt using aliases in from()? Until recently I've been using aliases to affect the resulting object, but it seems to have stopped working as it did before. Previously: 
const user = alias(User, "user");
const parent = alias(User, "parent");
const result = db
  .select()
  .from(user)
  .leftJoin(parent, eq(user.parentId, parent.id))
  .get();
console.log(result.user) // { user: {...}, parent: {...} }
const user = alias(User, "user");
const parent = alias(User, "parent");
const result = db
  .select()
  .from(user)
  .leftJoin(parent, eq(user.parentId, parent.id))
  .get();
console.log(result.user) // { user: {...}, parent: {...} }
In the current version, however, the query return type still has user in lowercase, but in the actual data it's uppercase, as if the alias is ignored (still working for innerJoin though).
3 Replies
bloberenober
bloberenober•15mo ago
seems like a regression will check
tacomanator
tacomanator•15mo ago
bloberenober
bloberenober•15mo ago
@tacomanator should be now fixed in 0.24.3
Want results from more Discord servers?
Add your server
More Posts
Table definition has 'any' typeI'm defining all of my tables in an `index.ts` file; but on some tables like `visitor_events` I get CTE query of hierarchical dataI'd like to drizzle-ize this query: ```sql WITH RECURSIVE Child(n) AS ( VALUES('...id') createInsertSchema wrong type (drizzle-zod 0.3.1, sqlite))After upgrading to 0.3.1, all of the fields changed to ZodTypeAnyHow do I get the values of an insert inside a transaction?I have this transaction where I create a project and add variables and a history of those variables.Raw sql`` quoting issueHi, I doing a work around until Drizzle supports generated columns. I have a manual script that addsNuxt3 type errorHello, is there somebody who used Drizzle in Nuxt3 project? I have problem with inheriting types froSyntax error mysql migration using composite primary key```sql --> statement-breakpoint CREATE TABLE `member_to_address` ( `member_id` varchar(32) NOT Nwhen using planetscale, using the `.$with()` and `.with()` clauses causes errorIs it not possible to use `$with()` and `with()` with planetscale? it gives the following error: `DaZod prototype mismatchEven though the Zod object constructor name created by Drizzle is ZodObject, it is not an instanceofunrecognized_keysGetting the following error when running generate:pg ``` ZodError: [ { "code": "unrecognized_k