Replace `latest_by_offset` with `CREATE SOURCE TABLE`

[ybyzek]

Porting confluentinc/ksqldb-recipes#158 here

From @mjsax

Using latest_by_offset is outdated. We should use the new CREATE SOURCE TABLE instead.

See discussion in confluentinc/ksqldb-recipes#144 (comment)

Just to add more color: there are for sure cases when latest_by_offset might still make sense. We should decide on a case-by-case basis.

Note to self: this is how one recipe was updated to use CREATE SOURCE TABLE: confluentinc/ksqldb-recipes@a051ebd

[ybyzek]

Note, cannot use INSERT INTO when using CREATE SOURCE TABLE.

Better create the table for the topic and a second table as CT t2 AS SELECT * FROM t1

confluentinc/ksqldb-recipes#144 (comment)