SQL Parity

[jterry64]

Pull request checklist

Please check if your PR fulfills the following requirements:

• [X] Make sure you are requesting to pull a topic/feature/bugfix branch (right side). Don't request your master!
• [X] Make sure you are making a pull request against the develop branch (left side). Also you should start your branch off our develop.
• [X] Check the commit's or even all commits' message styles matches our requested structure.
• [X] Check your code additions will fail neither code linting checks nor unit test.

Pull request type

Please check the type of change your PR introduces:

• [ ] Bugfix
• [X] Feature
• [ ] Code style update (formatting, renaming)
• [X] Refactoring (no functional changes, no api changes)
• [ ] Build related changes
• [ ] Documentation content changes
• [ ] Other (please describe):

What is the current behavior?

AS, LIMIT and ORDER BY are unsupported and will be ignored.

What is the new behavior?

• AS, LIMIT and ORDER BY statements will now behave the same as normal SQL
• Removed old unused data_lake.py file
• Made the timeout for the tiled lambda configurable, and slowed down for the tests since my local wifi was too slow
• Fixed the typo for the check interval to be 0.5 seconds instead of 0.05

Does this introduce a breaking change?

• [ ] Yes
• [X] No

[codecov[bot]]

Codecov Report

Merging #54 (bdc4cde) into develop (cffb583) will increase coverage by 2.92%. The diff coverage is 98.43%.

@@             Coverage Diff             @@
##           develop      #54      +/-   ##
===========================================
+ Coverage    91.57%   94.50%   +2.92%     
===========================================
  Files           20       19       -1     
  Lines         1140     1146       +6     
===========================================
+ Hits          1044     1083      +39     
+ Misses          96       63      -33     

Flag	Coverage Δ
unittests	94.50% <98.43%> (+2.92%)	:arrow_up:

Flags with carried forward coverage won't be shown. Click here to find out more.

Impacted Files	Coverage Δ
raster_analysis/query.py	96.53% <96.15%> (+0.40%)	:arrow_up:
lambdas/raster_analysis/src/lambda_function.py	76.92% <100.00%> (ø)
raster_analysis/globals.py	100.00% <100.00%> (ø)
raster_analysis/query_executor.py	92.47% <100.00%> (ø)
raster_analysis/tiling.py	99.07% <100.00%> (+0.06%)	:arrow_up:
tests/e2e/test_raster_analysis.py	100.00% <100.00%> (ø)

---

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update cffb583...bdc4cde. Read the comment docs.