I wrote a django app using postgres full text search. I ended up going with direct sql calls for anything more than a single record get because of all the spec

I wrote a django app using postgres full text search. I ended up going with direct sql calls for anything more than a single record get because of all the specialized syntax. It's nice to keep stuff like new record creation clean, but once you get more than one join deep it's time to break out the best domain specific language ever created.