WTH is there no (easy) way to add CSV imports to historical data

Month of "What the heck?!"
1

I have a few sensors where I have a historic data from a pre-Home Assistant era (power generation, living room temperature, …).
I would like to import this data to Home Assistant without having to mess around within the database itself.