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