A modern programming language that makes developers happier.

kotlinlang

Working with sqldelight and just need to add a new integer column.
```
Error migrating from 1.db, fresh database looks different from migration database:
/tables[myTable]/columns[myTable.someId]/ordinalPosition - CHANGED
  BEFORE:
    3
  AFTER:
    2```
Am I missing something here. Can you not add a new column into the middle of the table. Does it have to be at the end?

Edit: Did I really not know that you can't just add a column to the middle of a create statement and it has to go at the end? Hmmmmm

I guess I've been out of the database game for too long. hahaha. ON a more serious note. Early in my android career I used sqlite a ton. Then none at all for years. now a bunch of it again. thankful for the sqldelight migration test gradle task for catching this!

<https://www.sqlite.org/lang_altertable.html#alter_table_add_column>

&gt; The new column is always appended to the end of the list of existing columns.