title: Can the google spreadsheet 'query' function be used in google apps script?
body: <p>I'm looking for a way to programmatically populate a spreadsheet that filters data from another spreadsheet based on the logged in user.</p>
  
  <p>I am able to do this using the query function inside a spreadsheet. 
  BUT, unable to figure out a way to call the query function from apps script?</p>
  
  <p>Can this be done? Would appreciate sample code.
  Thanks.</p>