Lookpup Snaps - Query overwrite

There is no query overwrite option in the oracle/SQL server/Redshift lookup. It would be great if you add the below options in the lookup snaps.

  1. Query overwrite option in the lookup snap.
  2. As of now when multiple match found , lookup is returning result for all the matching records. If you provide an option to fetch the latest/oldest (First/last) value for the matching records would be very nice.