New car- petrol or diesel

[Peronipony]

Sorry for the boring topic.

I need a new car. Can’t afford one but that’s a different story. I need something big, have 3 kids and 2 dogs. Ideally not another people carrier because mine got scraped underneath constantly on rural potholes contributing to its trip to the scrap heap.

Im looking at either a rav4 or skoda kodiaq. Any thoughts on the above? I have a budget of 20k for something 2018 and up so can’t afford a Volvo or anything prestigious with the crazy prices at the moment.

Ive always had diesel but had lots of problems with EGR valves and DPF filters. Should I think about petrol instead? Will I get terrible mpg? I can’t afford electric so that’s not an option although I think the rav 4 is a hybrid (although smaller which is putting me off)

Any thoughts much appreciated as car shopping is the worst.

We have a Kia Sportage for the 3 kids or backseat passengers 2 border collies. Petrol. I had an astra estate 15 years old diesel, fantastic mileage, kept in top condition by retired vehicle technician DH, now belonging to my (disabled) DS. We wanted the Kia ceed, estate, easier to get a free holiday with the king! I had a 100 mile round trip to work. DH would accept a hybrid, not electric. Neighbour is a electrical engineer,one electric Citroen sitting in the garden 6 years, batteries US after 2 years. He does 20 miles,a day, now has a nissan leaf, home charger, 16 solar panels. He isn't happy with it,we actually bought the astra off him. He got terrible mileage but I reckon it was due to the short journeys and his driving.