How can I connect to a PostGIS database from ArcMap 9.3 or 10.0?

Ideally, I would like to be able to perform spatially enabled queries and receive the results back (e.g. spatial and non-spatial joins, filtering etc.) rather than just dumping the contents of a table.