Works great, IF the gas doesn't have too much Hydrogen Sulfide (a deadly but flammable poison), Nitrogen, Carbon Dioxide, or other contaminants. Or, too much condensate or water. And you have a big enough regulator to handle large changes in line pressure.
Bottom line, it is possible and safe with all the right equipment constantly maintained (separator, regulators, etc., etc.), but not advisable for the average layman householder. Unless you are both owner and pumper of the well, you will be much safer and happier with Propane.
Pete