I have a small app in flutter which uses a sqlite database through sqflite. I am trying to implement a simple migration:

• Add sql script to the application in design time.
• When the application starts, implement onCreate to look for the script files and execute them.

I don't want to list each file in the flutter: assets section in pubspec.yaml because I foresee I will have dozens of small sql scripts and listing them will be annoying.

I don't want to use drift because it's too heavy for what I want to do.

Is there a way to add the files to my app and list and read them?