SQLite Pivot and Cross Tab Queries

Is there any way to create a pivot and/or cross开发者_运维百科-tab query using for SQLite using any of the available .NET wrappers?

Thanks.

---

Not sure if this totally helps, but this link explains how to do basic pivots with the case statement: http://softwaresalariman.blogspot.com/2008/05/pivot-table-hack-in-sqlite3-and-mysql.html