TileDB or TileDB-R. Append new columns. Reshape data

1

How can I append new columns to a TileDB table?
How can I reshape a table (larger than memory) from wide to long formats or viceversa?
Is there any example on how to do it, specially from R, Python or Julia?