Change Details

[ENG-9779](https://linear.app/comm/issue/ENG-9779/create-separate-tables-for-thick-thread-data). This seems dumb to copy the code but not sure there is a better solution. Two alternative I can imagine are: 1. Using `CREATE TABLE AS SELECT` but it has some limitations: Primary keys are NOT preserved, other constraints may be lost (UNIQUE, NOT NULL, CHECK constraints, etc.) and column types might be inferred differently in some edge cases. 2. using SQLite's schema introspection to dynamically create identical tables, but this is hacky. Depends on D14836

[ENG-9779](https://linear.app/comm/issue/ENG-9779/create-separate-tables-for-thick-thread-data). This seems dumb to copy the code, but not sure there is a better solution. Two alternatives I can imagine are: 1. Using `CREATE TABLE AS SELECT` but it has some limitations: Primary keys are NOT preserved, other constraints may be lost (UNIQUE, NOT NULL, CHECK constraints, etc.), and column types might be inferred differently in some edge cases. 2. Using SQLite's schema introspection to dynamically create identical tables, but this is hacky. Note that in each case, whenever adding a schema migration, we'll have to migrate two tables at once, so this approach gives more visibillity that there are two tables with the same schema to update Depends on D14836

[ENG-9779](https://linear.app/comm/issue/ENG-9779/create-separate-tables-for-thick-thread-data). This seems dumb to copy the code, but not sure there is a better solution. Two alternatives I can imagine are: 1. Using `CREATE TABLE AS SELECT` but it has some limitations: Primary keys are NOT preserved, other constraints may be lost (UNIQUE, NOT NULL, CHECK constraints, etc.), and column types might be inferred differently in some edge cases. 2. uUsing SQLite's schema introspection to dynamically create identical tables, but this is hacky. Note that in each case, whenever adding a schema migration, we'll have to migrate two tables at once, so this approach gives more visibillity that there are two tables with the same schema to update Depends on D14836