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)."
"It also exposes app.Dao().DB() builder that allows executing various SQL statements (including raw queries)."
JavaScript API: https://pocketbase.io/docs/js-database/ Go API: https://pocketbase.io/docs/go-database/