To help with building up SQL queries, PetaPoco comes with a fluent SQL builder that can handle many basic tasks. The documentation for this is currently on the Old Documentation page. Here's a simple ...
To execute a query under the cursor or selected text, press Ctrl+Enter or right-click the query and click Execute-> Execute SQL Statement on the context menu. You can do the same using the main ...