Well, the database functionallity added to kicad in v7 opened the door to really customizing your own work system. I set up a sqlite db and it has been great. You need to do a bit of work to get there.
I also tweaked a bom script so I could access my fields as I wanted and create a bom to my liking, to generate this for example:
Here is my script if you wish to tweak it to your own needs (I just hacked on one of the kicad-provided scripts to customize it):
bom_csv_gil_script.zip (8.7 KB)