SQL

I often have to store hierarchies of data to a SQL database. Is there a more efficient method other than an adjacency list (Records have parent columns to store their relationships). It is fine for somethings. But is there a more complete and better way? Is there a viable alternative?

Yeah, it's called not using SQL. Store everything as sex peas and then write a sex-pea parser to load them back in.