Comment by turtlebits
2 years ago
I like the idea, but after using it, the query apis aren't expressive enough. I wish I could write SQL instead of making 2+ api calls to get the data I want.
2 years ago
I like the idea, but after using it, the query apis aren't expressive enough. I wish I could write SQL instead of making 2+ api calls to get the data I want.
I'm no expert, but it seems like raw SQL is supported. From the docs:
"It also exposes app.Dao().DB() builder that allows executing various SQL statements (including raw queries)."
Yes, that's correct. In server-side code, you can write SQL queries.
JavaScript API: https://pocketbase.io/docs/js-database/ Go API: https://pocketbase.io/docs/go-database/
Did you try view collections, https://pocketbase.io/docs/collections/#view-collection ?