You asked
Is the sigma 12mm f 1 4 dc contemporary good in low light?
Yes, it's a strong choice for low light. The Sigma 12mm f/1.4 DC Contemporary has a wide f/1.4 maximum aperture, so it gathers far more light than a typical kit zoom. On Sony E or Fujifilm X it frames like 18mm on full frame and gives about the depth of field of f/2.1.
The catch is that it isn't stabilised, so in dim rooms you'll need a steady hand or a faster shutter speed. If low light is your main job, the sensor sizes guide explains when full frame is worth the extra cost. For more on why fast primes help in dim conditions, see primes or zooms.
Written by Claude from this site's pages.