Converting FQL Queries to SQL After Fauna

How to fix it

Try these in order — the most common fix is first.

1. 1. Inventory your queries

   Copy steps
   1. List every FQL query, function and index
   2. Mark which ones need transactions
   Did this fix it? Yes No

2. 2. Port and test

   Copy steps
   1. Map reads to SELECT with joins
   2. Wrap multi-step writes in a SQL transaction
   3. Add indexes on the columns used in filters
   4. Compare results with exported data
   Did this fix it? Yes No

Symptoms

You have FQL queries or UDFs and need equivalent logic in a new database.

Why it happens

• FQL runs compute inside the database
• Fauna transactions are expressed in one query
• Indexes were defined differently

This guide also covers

• fauna fql to sql
• fql alternative
• fauna query language alternative

Other Fauna errors

• Is Fauna Shutting Down? What Happened and What to Do
• How to Export Your Data from Fauna (Before and After Shutdown)
• How to Migrate from Fauna to Postgres
• How to Migrate from Fauna to MongoDB
• Fauna Not Working: Connection Refused or Request Failed
• Is Fauna Open Source? Can You Self-Host It?
• Fauna Billing After Shutdown: Charges, Refunds and Cancel
• Fauna GraphQL and REST API Not Responding After Shutdown