alter_table.txt

/* Suppose I have the following table: */
CREATE TABLE {table} (
{id} STRING PRIMARY KEY,
{name} STRING NOT NULL COLLATE LOCALIZED,
{data} BLOB
)

/*
 * Where {data} is is large object such as:
 * class Data(
 *	 val name: String, // <-- Same as {name} field in table
 *	 // ... Whole bunch of other stuff
 * )
 */
 
/*
 * I want to:
 * 1. Change STRING to TEXT type for {table}.{name} column
 * 2. Populate updated {table}.{name} column with information from {table}.{data.name}
 */
 
/* What would the ALTER TABLE statement look like? Mostly unsure of how to select fields from a BLOB. I got this far: */
ALTER TABLE {table} DROP COLUMN {name};
ALTER TABLE {table} ADD COLUMN {name} TEXT NOT NULL COLLATE LOCALIZED;
UPDATE {table} SET {name} = ???