Recommend what is better to use SQLITE / ORM?

Question

Android

Advise what is better to use in such cases:

1. first I get a list of tables :
   

[{"id":0,"name":"Device"},{"id":1,"name":"Elements"}]

1. then the structure of each table:
   

{"status":"OK","TableStructure":{"Data_type":[{"name":"id","allowNull":false,"dbType":"bigint","defaultValue":null,"size ":null,"precision":null,"visible":false},{"name":"element","allowNull":true,"dbType":"character varying(20)","defaultValue":null, "size":20,"precision":20,"visible":true},{"name":"create_user_id","allowNull":true,"dbType":"bigint","defaultValue":null,"size ":null,"precision":null,"visible":false},{"name":"create_datetime","allowNull":true,"dbType":"timestamp without time zone","defaultValue":null,"size":null,"precision":null,"visible":false},{"name":"update_user_id","allowNull":true,"dbType":"bigint","defaultValue ":null,"size":null,"precision":null,"visible":false},{"name":"update_datetime","allowNull":true,"dbType":"timestamp without time zone"," defaultValue":null,"size":null,"precision":null,"visible":false}],"Relations":[{"type":"CHasManyRelation","model":"Test","field" :"elem","visible":false,"model_field_view":""}]}}visible":false},{"name":"update_user_id","allowNull":true,"dbType":"bigint","defaultValue":null,"size":null,"precision":null,"visible" :false},{"name":"update_datetime","allowNull":true,"dbType":"timestamp without time zone","defaultValue":null,"size":null,"precision":null,"visible ":false}],"Relations":[{"type":"CHasManyRelation","model":"Test","field":"elem","visible":false,"model_field_view":""}] }}visible":false},{"name":"update_user_id","allowNull":true,"dbType":"bigint","defaultValue":null,"size":null,"precision":null,"visible" :false},{"name":"update_datetime","allowNull":true,"dbType":"timestamp without time zone","defaultValue":null,"size":null,"precision":null,"visible ":false}],"Relations":[{"type":"CHasManyRelation","model":"Test","field":"elem","visible":false,"model_field_view":""}] }}size":null,"precision":null,"visible":false},{"name":"update_datetime","allowNull":true,"dbType":"timestamp without time zone","defaultValue":null, "size":null,"precision":null,"visible":false}],"Relations":[{"type":"CHasManyRelation","model":"Test","field":"elem", "visible":false,"model_field_view":""}]}}size":null,"precision":null,"visible":false},{"name":"update_datetime","allowNull":true,"dbType":"timestamp without time zone","defaultValue":null, "size":null,"precision":null,"visible":false}],"Relations":[{"type":"CHasManyRelation","model":"Test","field":"elem", "visible":false,"model_field_view":""}]}}type":"CHasManyRelation","model":"Test","field":"elem","visible":false,"model_field_view":""}]}}type":"CHasManyRelation","model":"Test","field":"elem","visible":false,"model_field_view":""}]}}
and I have to generate tables, and then I need to generate a form for each table and work with them .
Thanks for your attention, I'm looking forward to your reply.

Answer 1

and i have to generate tables

ormlite
wait five years, maybe something will appear for this ...
this is not a web .... it’s not very web, for example, it’s quite normal and you can even say the classic approach, first write to the database then show (one of the things that shocks many web developers ) and there are a lot of such moments, almost everything has to be cut by hand

Answer 2

The topic was raised - Android SQLite which ORM framework are you using?