I am able to get results using do the above mentioned mysql functions as part of raw SQL query yields correct results but being able to do this with Models would help me greatly. # raw query query = ...