Hydrolyzes glucose-6-phosphate to glucose in the endoplasmic reticulum. May be responsible for glucose production through glycogenolysis and gluconeogenesis (By similarity). D-glucose 6-phosphate + H2O = D-glucose + phosphate Carbohydrate biosynthesis; gluconeogenesis. Belongs to the glucose-6-phosphatase family.