sql: Add SQL queries for candidates and known informaiton