Platform
Resources
Pricing
Sign in
Get started
Nhogs
Workspace
Fork
Public
By
Frederic Ciminera
Edited
Aug 11, 2023
Insert cell
Insert cell
Insert cell
data
=
`CREATE TABLE user(
id INT PRIMARY KEY NOT NULL,
first_name VARCHAR(100),
last_name VARCHAR(100)
)`
Insert cell
data
.
match
(
"([a-z_]+ )[A-Z 0-9()]*,?[ \r\n]*"
)
Insert cell
ast
=
JSON
.
stringify
(
parser
.
astify
(
sql
)
,
null
,
2
)
Insert cell
parser
=
new
sqlParser
.
default
.
Parser
(
)
Insert cell
Insert cell
Insert cell
sqlParser
=
import
(
"https://cdn.skypack.dev/node-sql-parser@4.9.0?min"
)
Insert cell
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Try it for free
Learn more
Fork
View
Export
Edit
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
sql
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
data
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Add comment
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
ast
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
parser
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
sqlts
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
Edit
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML
sqlParser
Add comment
Copy import
Select
Duplicate
Copy link
Embed
Delete
JavaScript
Markdown
HTML