how to use magical sql with transactions?

[avnav0]

trying something like:

const result: any = await drizzleDb.transaction(async (tx) => {
   let select_result = await tx.execute(sql`select 1`)
}

it says:

Property 'execute' does not exist on type 'SQLiteTransaction

[Angelelz]

SQLite has .run() and .get():

const result = await db.transaction(async (tx) => tx.get(sql`select 1`));