title: How to see/update database version? Is there something like "fallbackToDestructiveMigration"?
body: <p>After modifying the <strong>sq</strong> file by renaming one of the tables and adding one more table I didn't find any place to specify that database schema or version has been changed and I want no migration - just recreate database. The documentation on <a href="https://cashapp.github.io/sqldelight/multiplatform_sqlite/migrations/" rel="noreferrer">official website</a> does not contain any information about this.</p>
  <p>Project compiles but when I run the app on both Android and iOS I get a runtime crash and in logs it says that added table does not exist.</p>
  <p>I tried adding version in build.gradle.kts of shared module but I still get runtime crash:</p>
  <pre><code>sqldelight {
     database(&quot;MyDatabase&quot;) {
        packageName = &quot;com.example.shared.cache&quot;
        version = 2 // added this line only
     }
  }
  </code></pre>
  <p>I don't want to delete and reinstall the app. Ideal solution would be something like <a href="https://developer.android.com/reference/android/arch/persistence/room/RoomDatabase.Builder#fallbackToDestructiveMigration()" rel="noreferrer">fallbackToDestructiveMigration</a> Room database has</p>
  <p>I found <a href="https://github.com/cashapp/sqldelight/issues/1213" rel="noreferrer">this discussion</a> about a destructive migration. Last comment suggests to handle that in platform specific drivers but it doesn't show how to do that.</p>
  <p>So my questions are:</p>
  <ol>
  <li>How to change the database version?</li>
  <li>How to setup destructive migration?</li>
  </ol>
  <p>I wish documentation was more detailed on various topics. It would make finding right information easier for developers like me who is not very experienced in Sqlite.</p>