The idea is to improve the SQL language, specifically the join syntax, for the special but common case when joining on foreign key columns.
Example below taken from PostgreSQL documentation [1]
In SQL-89, we didn't have any JOIN syntax yet, so queries were written in this way:
| #!/bin/bash | |
| echo "limon" > encdec.dec | |
| echo "Encrypt" | |
| openssl enc -aes-256-cbc -md sha512 -pbkdf2 -iter 10000 -salt -in encdec.dec -out encdec.enc | |
| ls encdec.* | |
| # encdec.enc encdec.dec |
| package main | |
| import ( | |
| "fmt" | |
| "net/http" | |
| "net/http/httputil" | |
| "net/url" | |
| ) | |
| func main() { |
| function my_rest_prepare_post( $data, $post, $request ) { | |
| $_data = $data->data; | |
| $thumbnail_id = get_post_thumbnail_id( $post->ID ); | |
| $thumbnail = wp_get_attachment_image_src( $thumbnail_id ); | |
| $_data['featured_image_thumbnail_url'] = $thumbnail[0]; | |
| $data->data = $_data; | |
| return $data; | |
| } | |
| add_filter( 'rest_prepare_post', 'my_rest_prepare_post', 10, 3 ); |
| <!doctype html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <title>Bootstrap 3.0 Grid System</title> | |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
| <!-- Latest compiled and minified CSS --> | |
| <link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css"> | |
| <style> | |
| body{ |
