issue_comments: 1316400688

This data as json

html_url	issue_url	id	node_id	user	created_at	updated_at	author_association	body	reactions	issue	performed_via_github_app
https://github.com/simonw/datasette/pull/1893#issuecomment-1316400688	https://api.github.com/repos/simonw/datasette/issues/1893	1316400688	IC_kwDOBm6k_c5Odq4w	9599	2022-11-16T05:49:31Z	2022-11-16T05:49:31Z	OWNER	OK, I decided to play around with GPT-3 for this. https://beta.openai.com/playground I prompted: ``` For each keyword say it it can be used in a SQLite select statement: and as asc between by case cast cross current current_date current_time current_timestamp desc detach distinct each else end escape except exclude exclusive exists explain fail filter first following for foreign from full generated glob group groups having if ignore immediate in index indexed initially inner insert instead intersect into is isnull join key last left like limit match materialized natural no not nothing notnull null nulls of offset on or order others outer over partition plan pragma preceding primary query raise range recursive references regexp reindex release rename replace restrict returning right rollback row rows savepoint select set table temp temporary then ties to transaction trigger unbounded union unique update using vacuum values view virtual when where window with without and: yes as: yes asc: yes between: yes by: yes case: yes cast: yes current: yes current_date: yes current_time: yes current_timestamp: yes desc: yes detach: no distinct: yes each: yes else: yes end: yes escape: yes except: no exclude: yes exclusive: no `Having given it these examples I ran it a few times:` exists: yes explain: no fail: no filter: yes first: yes following: no for: yes foreign: no from: yes full: no generated: no glob: yes group: yes groups: no having: yes if: yes ignore: no immediate: no in: yes index: yes indexed: no initially: no inner: no insert: no instead: no intersect: no into: yes is: yes isnull: yes join: yes key: no last: yes left: yes like: yes limit: yes match: no materialized: no -natural: yes no: no not: no nothing: no notnull: yes null: yes nulls: yes of: no offset: yes on: yes or: yes order: yes others: yes outer: no over: no partition: no pragma: no preceding: no primary: no query: no raise: no range: no recursive: no references: no regexp: yes reindex: no release: no rename: no replace: no restrict: no returning: yes right: yes rollback: no row: yes rows: no savepoint: no select: yes set: no table: yes temp: yes temporary: yes then: yes ties: no to: yes transaction: no trigger: no unbounded: no union: yes unique: yes update: no using: yes vacuum: no values: yes view: yes virtual: no when: yes where: yes window: no with: yes without: no `I added this:` A space separated list of all of the keywords for which the answer was yes: `It replied:` and as asc between by case cast current current_date current_time current_timestamp desc distinct each else escape except exists explain filter first for from full generated group having if in index inner intersect into isnull join last left like limit not null or order outer over pragma primary query raise range regexp right rollback row select set table temp temporary then to union unique using values view virtual when where `Then I tried doing this:` Produce a short summary of how each of those are used: and: ``` This kind of worked too! It ended up defining every keyword, not just the ones for which the "is it used in select" was "yes", but it gave me this list: and: Used to combine multiple conditions in a WHERE clause as: Rename a column or table in the output of a query asc: Sort results in ascending order between: Used in a WHERE clause to specify a range by: Specifies how to sort the results of a query case: Used to create different outputs based on conditions cast: Converts a value from one data type to another current: Returns the current date, time, or timestamp current_date: Returns the current date current_time: Returns the current time current_timestamp: Returns the current timestamp desc: Sort results in descending order distinct: Selects only unique values each: Used with aggregate functions else: Used with the CASE statement escape: Used to escape special characters in a string except: Returns all rows from the first query that are not in the second query exists: Used with subqueries explain: Analyzes a query and returns information about it fail: Used with the ON CONFLICT clause filter: Used to specify conditions for aggregate functions first: Used to specify conditions for aggregate functions following: Used with window functions for: Used to specify conditions for aggregate functions foreign: Creates a foreign key from: Specifies the table(s) to select data from full: Used with outer joins generated: Used with generated columns glob: Used to match a string with a pattern group: Groups together rows that have the same values groups: Used with aggregate functions having: Specifies conditions for groups if: Used with the ON CONFLICT clause ignore: Used with the ON CONFLICT clause immediate: Used with the ON CONFLICT clause in: Used to check if a value is in a list index: Creates an index on a column or columns indexed: Used with the ON CONFLICT clause initially: Used with the ON CONFLICT clause inner: Creates an inner join insert: Inserts new data into a table instead: Used with triggers intersect: Returns all rows that are in both queries into: Specifies the table to insert data into is: Used to compare values isnull: Checks if a value is null join: Joins two or more tables together key: Creates a primary key or unique key last: Used to specify conditions for aggregate functions left: Creates a left join like: Checks if a value matches a pattern limit: Specifies the maximum number of rows to return not: Negates a condition null: Specifies a null value nulls: Used with the ORDER BY clause of: Used with window functions offset: Specifies the number of rows to skip on: Specifies conditions for a join or: Checks if either condition is true order: Specifies how to sort the results of a query others: Used with the CASE statement outer: Creates an outer join over: Used with window functions partition: Used with window functions pragma: Used to query or change various internal settings preceding: Used with window functions primary: Creates a primary key query: Used with the ON CONFLICT clause raise: Used with the ON CONFLICT clause range: Used with window functions recursive: Used with common table expressions references: Creates a foreign key regexp: Checks if a value matches a regular expression reindex: Recreates an index release: Used with savepoints rename: Changes the name of a table or column replace: Inserts new data into a table or updates existing data restrict: Used with savepoints returning: Returns data from inserted or updated rows right: Creates a right join rollback: Rolls back a transaction row: Used with aggregate functions select: Selects data from a table set: Changes the value of a column table: Specifies the table(s) to select data from temp: Creates a temporary table temporary: Creates a temporary table then: Used with the CASE statement ties: Used with the ORDER BY clause to: Used with common table expressions transaction: Starts a transaction trigger: Creates a trigger unbounded: Used with window functions union: Returns all rows from both queries unique: Creates a unique constraint update: Updates existing data in a table using: Specifies the table(s) to join vacuum: Optimizes a database values: Specifies the values to insert into a table view: Creates a view virtual: Creates a virtual table when: Used with the CASE statement where: Specifies conditions for a query window: Used with window functions with: Specifies common table expressions used in a query without: Used with indexes	{ "total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0 }	1450363982