René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Missing alias in `PostgreSQLOfflineStore.pull_all_from_table_or_query()`","articleBody":"## Expected Behavior\r\nCall `pull_all_from_table_or_query()` method and retrieve wanted data from offline store.\r\n\r\n## Current Behavior\r\nSQL error `psycopg2.errors.SyntaxError: subquery in FROM must have an alias`\r\n\r\n## Steps to reproduce\r\nCall `pull_all_from_table_or_query()` on `PostgreSQLOfflineStore`, where `PostgreSQLSource` is initialized with `query=\"SELECT * FROM table_name\"`\r\n### Specifications\r\n\r\n- Version: 0.22.1\r\n- Platform: x86_64\r\n- Subsystem: Linux 5.18\r\n\r\n## Possible Solution\r\n\r\nAdding alias in query located in `PostgreSQLOfflineStore.pull_all_from_table_or_query()`, for example adding `AS dummy_alias`. This was tested on my use-case and it works as expected, and if it looks ok, I could open a PR with this change.\r\n\r\n```\r\nquery = f\"\"\"\r\n            SELECT {field_string}\r\n            FROM {from_expression} AS dummy_alias\r\n            WHERE \"{timestamp_field}\" BETWEEN '{start_date}'::timestamptz AND '{end_date}'::timestamptz\r\n        \"\"\"\r\n```","author":{"url":"https://github.com/ikrizanic","@type":"Person","name":"ikrizanic"},"datePublished":"2022-07-20T06:28:22.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2954/feast/issues/2954"}