Below are the sql query to use for additional fields:

1. For select query aditionalfields:

Following is a wrong example:

select column10000105 from Table345

Following is a right example if 10000105 is text:

New: select  get(a.additionalfields,'column10000105','') from Table345 as a 

Following is a right example if 10000105 is numeric:

New : select  get(a.additionalfields,'column10000105','0') from Table345 as a ;

2. For Update additional fields:

Following is a right example if 10000105 is text:

update table345 set additionalfields=set(additionalfields,'column10000105','HT2','') where id=36;  

where HT2 is the value to be updated for id=36 for table345 additionalcolumn 10000105.

Following is a right example if 10000106 is numeric:

update table345 set additionalfields=set(additionalfields,'column10000106','100','0') where id=36;