5 replies

Drizzle generates PG statement with parentheses on order by clause

Hello!

I'm trying to execute a simple query with Drizzle, but it generates an invalid SQL statement.

import { desc, eq } from 'drizzle-orm';
await db
  .select()
  .from(messages)
  .where(eq(messages.conversationId, id))
  .orderBy([desc(messages.id)])
  .limit(10)

import { desc, eq } from 'drizzle-orm';
await db
  .select()
  .from(messages)
  .where(eq(messages.conversationId, id))
  .orderBy([desc(messages.id)])
  .limit(10)

This is the generated SQL:

select "id", "conversation_id", "content", "created_at", "updated_at"
from "messages"
where "messages"."conversation_id" = $1
order by ("messages"."id" desc)
limit $2

select "id", "conversation_id", "content", "created_at", "updated_at"
from "messages"
where "messages"."conversation_id" = $1
order by ("messages"."id" desc)
limit $2

(error: syntax error at or near "desc" at character 113)

(error: syntax error at or near "desc" at character 113)

Looks like a parentheses is added on the order by clause. Am I doing something wrong?

Drizzle Team•3y ago•

5 replies

thiagozf

Drizzle generates PG statement with parentheses on order by clause

Hello!

I'm trying to execute a simple query with Drizzle, but it generates an invalid SQL statement.

import { desc, eq } from 'drizzle-orm';
await db
  .select()
  .from(messages)
  .where(eq(messages.conversationId, id))
  .orderBy([desc(messages.id)])
  .limit(10)

import { desc, eq } from 'drizzle-orm';
await db
  .select()
  .from(messages)
  .where(eq(messages.conversationId, id))
  .orderBy([desc(messages.id)])
  .limit(10)

This is the generated SQL:

select "id", "conversation_id", "content", "created_at", "updated_at"
from "messages"
where "messages"."conversation_id" = $1
order by ("messages"."id" desc)
limit $2

select "id", "conversation_id", "content", "created_at", "updated_at"
from "messages"
where "messages"."conversation_id" = $1
order by ("messages"."id" desc)
limit $2

(error: syntax error at or near "desc" at character 113)

(error: syntax error at or near "desc" at character 113)

Looks like a parentheses is added on the order by clause. Am I doing something wrong?

Drizzle generates PG statement with parentheses on order by clause

Similar Threads

Drizzle generates PG statement with parentheses on order by clause

Similar Threads

Similar Threads

Similar Threads