Under the hood? I believe MariaDB, but thankfully, I never had to write a single SQL query. I used Appwrite SDK to do operations like db.getDocument, db.listDocuments, db.createDocument...
Most technologies come and go. So when Appwrite goes away, your applications will fall apart?