DxO conclusion is:

Not everyone wants large and heavy high-speed lenses, so there’s clearly an opportunity for compact high-quality primes. With such strong contenders in Sony’s lineup at this focal length, though, it is perhaps no surprise to see Sigma offering something a little different with the Sigma 90 mm F2.8 DG DN | Contemporary lens. Despite some slight shortcomings, many of which can be overcome with software correction, image quality is very good overall. What’s more, if portraiture is your thing, thanks to its small size, great build, and relatively affordable pricing, the Sigma 90 mm F2.8 DG DN | Contemporary looks like a super-compelling option.

A full spec comparison with Sony cameras can be seen on that special BHphoto page

Dpreview compared the two cameras and came to the following conclusion:

The Sony ZV-E10 and Nikon Z30 are very similar cameras in many respects, which makes it a little hard to choose between them.

If we were primarily shooting stills, we’d probably opt for the Nikon. The better kit zoom and smoother sharing experience with Snapbridge definitely count in its favor, as does its front-and-rear dial control setup. Its full-width video if you want 4K/30 is also a distinct advantage.
However, the Sony’s better battery life, the inclusion of a headphone socket, and the much wider choice of lenses are all compelling benefits, if you plan to move beyond using the 16-50mm power zoom. It exhibits a lot of rolling shutter effect in video, which is a major black mark against it. But it’s the ZV-E10’s autofocus that gives it the edge for us. It’s easier and quicker to use when shooting stills and that bit more reliable when shooting video, and we don’t think the Nikon has enough to counter that.