title: How can I allow users sql access to a table limited to certain rows?
body: <p>I'm building an stock exchange simulation game. I have a table called 'Market_data' and in the game players simulate being in particular dates and are allowed to use SQL queries to retrieve the historical data and plan their course of action. My difficulty is that I need to limit the rows they can access based on the current date they are playing on so they cant see rows with a date greater than the current date.</p>
  
  <p>Eg: An user is running the game and is currently in the year 2010, if he does a simple select like <code>"SELECT * FROM market_data"</code> I don't want him to see rows with Date > 'x-x-2010'</p>
  
  <p>The only soution that I know of is to parse the user's SQL and add WHERE clauses to remove newer dates but it seems time consuming and prone to errors and I wasn't sure whether there were better alternatives. Any ideas on how to do this right will be thanked.</p>