SELECT STRING_AGG(variable_definition.kotlin, ',') AS kotlin_variable_definition,STRING_AGG(result_set.kotlin, ',') AS kotlin_result_setFROM INFORMATION_SCHEMA.COLUMNS col,LATERAL ( SELECT CASE WHEN data_type = 'integer' THEN 'Int' WHEN data_type = 'text' THEN 'String' WHEN data_type = 'character varying' THEN 'String' WHEN data_type = 'numeric' THEN 'Double' WHEN data_type = 'double precision' THEN 'Double' WHEN data_type = 'jsonb' THEN 'String' WHEN data_type = 'boolean' THEN 'Boolean' WHEN data_type = 'timestamp without time zone' THEN 'String' WHEN data_type = 'timestamp with time zone' THEN 'String' END AS kotlin, CASE WHEN data_type = 'integer' THEN 'Integer' WHEN data_type = 'text' THEN 'String' WHEN data_type = 'character varying' THEN 'String' WHEN data_type = 'numeric' THEN 'Double' WHEN data_type = 'double precision' THEN 'Double' WHEN data_type = 'jsonb' THEN 'String' WHEN data_type = 'boolean' THEN 'Boolean' WHEN data_type = 'timestamp without time zone' THEN 'String' WHEN data_type = 'timestamp with time zone' THEN 'String' END AS java ) AS alt_data_types,LATERAL ( SELECT 'val '||column_name||': '||alt_data_types.kotlin||CASE WHEN is_nullable = 'YES' THEN '?' ELSE '' END AS kotlin) AS variable_definition,LATERAL ( SELECT 'rs.get'||alt_data_types.kotlin||'("'||column_name||'")' AS kotlin) AS result_setWHERE table_schema = 'consoleweb' AND table_name = 'sensor';