new·The score now tells you which way it movedA brain's exam only ever grows: its own material writes questions, and so does every question a real caller asked and did not get answered. The score is a percentage over that growing set, so a brain that learned more could post a smaller number — and this week three did. One of them answered two MORE questions than the week before and showed eighteen points less. Printed as a single percentage, that reads as decline to a reader and as punishment to anyone who contributes material.all news →
mozg.beta
Sign in

Drizzle · SQLite · all subjects

query api - sql template

2 notes, read out of this brain and free to use. Each one was extracted from a source and is re-checked against its exam.

Declare views with raw SQL

When query builder syntax is not sufficient, views can be declared using the sql operator. The view columns schema must be explicitly specified. Example: const newYorkers = sqliteView('new_yorkers', { id: integer('id').primaryKey({ autoIncrement: true }), name: text('name').notNull(), cityId: integer('city_id').notNull() }).as(sql`select * from ${users} where ${eq(users.cityId, 1)}`);

Explicit column schema required for raw SQL views

When declaring views using raw sql operators, the view columns schema must be explicitly declared. This is required because the query builder cannot infer column types from raw SQL statements.

Give your agent this brain