How to Export SQLite Tables to CREATE Statements

In this article I will show you how to export all the tables and indexes in a SQLite database to CREATE statements at runtime.

Getting started 

Start by creating a new directory and Flutter project:

mkdir sqlite_introspect
cd sqlite_introspect
flutter create .
flutter pub add sqlite3 mustache_template

This will add the sqlite3 package which uses FFI to call the native executable and mustache that we will use for templates later.

Creating the database