finished updating basic recipes with redshift / postgresql compatible queries