Back

any support in future for using sql to query data

  • 0
  • Self Hosted
  • Tools
  • Web
  • Databases
Suiii
27 Oct, 2023, 13:10

Not connecting to mariadb but can be done on console or using sdk alike to write sql syntax , something implemented in super-base.

TL;DR
Message: The user is asking if there will be support for using SQL to query data in the future. They mention a related issue on GitHub and express the need for features like counting and using OR in queries. They want to use complex SQL queries in their project while migrating to Appwrite for reporting purposes. Someone suggests that Appwrite plans to have support for both SQL and No-SQL databases in the future, so they may not implement SQL support. Another user questions why the OP wants to use SQL when Appwrite doesn't require it. The user clarifies that they don't want to connect to Mariadb directly, but rather write
ZachHandley
27 Oct, 2023, 15:05

I’m curious, one of my favorite parts of Appwrite is not having to use SQL haha, why do you want to use it?

D5
27 Oct, 2023, 15:13

I don't think that will be implemented, mainly because the Appwrite plans in a future is to have support for both SQL and No-SQL databases

Suiii
27 Oct, 2023, 15:20

I want to you my complex sql queries in the my current project when migrating to appwrite for reporting.

Suiii
27 Oct, 2023, 15:20

queries are missing the sql synax , like OR, and so on.

D5
27 Oct, 2023, 15:20

"Or" support for queries is under request

Suiii
27 Oct, 2023, 15:21

what about something like count *

ZachHandley
27 Oct, 2023, 15:33

.length?

Drake
27 Oct, 2023, 21:49

I suggest you 👍🏼 this related issue: https://github.com/appwrite/appwrite/issues/5667

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more