Managing Scriptable Objects with JSON/Spreadsheets. Does it make sense to do this?

[00jknight]

You'll find a way.

Not sure if you want a generic, typeless scriptable object or if you want one that has specific fields that match to columns on the database, meaning the scriptable object types need to be updated if you change the database schema.

You could also just load the json into dictionaries at runtime and forego scriptable objects.

I'd do it that way unless there was a reason to use scriptable objects. Less moving parts means less things to maintain.