Having said that, (IIRC) the CDR table gets written the way you describe. The entry gets updated with information after the call is complete.
It sounds like you need to get an AMI process going where you get information ‘asynchronously’ and write that to your database. It’s a lot of effort and I’m pretty sure there are already processes in place that do most of the work, but it sounds like what you really need.