how do you import alias

[avnav0]

the docs have:

import { user } from "./schema";
 
const parent = alias(user, "parent")
const result = db
  .select()
  .from(user)
  .leftJoin(parent, eq(parent.id, user.id));

select ... from "user" left join "user" "parent" on "parent"."id" = "user"."id"
// result type
const result: {
    user: {
        id: number;
        name: string;
        parentId: number;
    };
    parent: {
        id: number;
        name: string;
        parentId: number;
    } | null;
}[];

but they don't tell you how to import alias...

i get:

Module '"drizzle-orm"' has no exported member 'alias'.ts(2305)
import alias

[avnav0]

nope...

import { eq, desc } from "drizzle-orm";
import alias from 'drizzle-orm'

This expression is not callable.
Type 'typeof import("/home/proj/node_modules/drizzle-orm/index")' has no call signatures.ts(2349)
import alias

├── [email protected]
├── [email protected]

using turso by the way

[avnav0]

### Join aliases and self-joins

```typescript
import { ..., alias } from 'drizzle-orm/sqlite-core';

export const files = sqliteTable('folders', {
  name: text('name').notNull(),
  parent: text('parent_folder')
})

...
const db = drizzle(...);

const nestedFiles = alias(files, 'nested_files');
db.select().from(files)
  .leftJoin(nestedFiles, eq(files.name, nestedFiles.name))
  .where(eq(files.parent, '/'))
  .all();
// will return files and folders and nested files for each folder at root dir