How can I create a custom database table using a code and have it upgrade friendly?
I don't want to create a new module just for this since it will just store data that is generated automatically.
Since you are using CE you are on Site and have full control of your database.
If you want to use the beans and all that they facilitate you will need to create a Module, thus creating the metadata for the Bean. You can then hide the module from the users using the Admin settings.
If you just want a table in the database then use your RDBMS to create the table and manipulate its contents with SQL statements for your CRUD operations.
I guess this is the only plausible solution at the moment then. Thank you
Retrieving data ...