Importing dataset from external SQL database

[george-lim]

Hi there!

I have a project that could benefit from using a graph database to generate insights on my database, but does not require real-time processing. As such, I figure that it would make more sense (from a performance standpoint) to use a simple SQL database to manage user state, and only use Cozo when I need to periodically process the entire database.

This design would require me to import a snapshot of the entire database into Cozo and use Cozo as a computation engine to process the database.

Since Cozo can backup from / restore to a SQLite database, I'm wondering if there is a way for me to store data in my SQL database in a way that Cozo can import it, without using Cozo.

Another benefit to this design is that I can leverage the infrastructure provided by existing serverless databases while still using Cozo to handle complex recursive queries.

My two questions are:

1. Does this design make sense as a valid use case for Cozo?
2. If so, how would I go about doing this?