Is it possible to insert a field in to a table using a form?

Hello all,

I have a requirement to insert custom fields in to a dataset, say user defined address 1, or an additional yes no requirement on a record. 

Is this possible in knack? 

in sql it would be for example 

ALTER TABLE table_name
ADD column_name data_type column_constraint;