After having some discussion on github. we decided to support 'static' columns in SQLite3 by create a new '_static' table.
Here's the rough roadmap
- Create a new table with foreign key
- On each insert in main table with "static columns"
- Do insert a new row in static table - done
- Update other static columns with new static columns
- On each get with static columns perform a join with static table