{"format":1,"manifest":{"name":"sql-snippets","publisher":"vyloxi","version":"1.1.0","displayName":"SQL Snippets","description":"Queries, joins, windows, indexes and migrations for the built-in SQL language.","engines":{"ferrum":"^0.1.0"},"categories":["Snippets"],"icon":"icon.png","repository":"https://github.com/voukengdongmofrankysteve/ferrum-market","license":"MIT","contributes":{"snippets":[{"language":"SQL","path":"snippets/sql.json"}]}},"files":{"icon.png":{"encoding":"base64","content":"iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAYAAADDPmHLAAAqOUlEQVR42u19eZhc1XXn79x736utF3W31FpaCwIhCTBgSGRs7EAgDnhNxsmIzCROMpnszufEcRKPMR635MQhEyeeBGZim0xW/H2ZqMczSWa84BAwi4mxkMRiJIFAEoLe1XtVV73l3jN/vFfVtderpbX4U/G1UJdevXfr/u496++cS2jxdWDvXrn3wIghAgMAP3qrGnmCr/J892ajcaPvmxsM8yYpaMg3zAQiLnyai/4sfXGUh3PjzzCav6bxozjKcGq8xw3HXfYsFkKQMTxKhDFL4YgQOGyR9dT2H4odu+22x/zgKtDIXXvFXSMjuhUcqdkPDA9D7NsHzgN/4NO3XOvknA9qw+9mxs5kXMVsS0AJAgiwlag6GdwK8GUXtgIytwNgq4uKueXxuL4GM6A1w/U1co52iOhlQfS1eFJ96T9+6tsv5BfCvn2g/fthVm0BHDiwV951V7DS/u6em+/wWP+OMXx7b5ctYpZAKq6QiEsTU4KlFMQACVp5BkeYRK4JOncc6OiLkFtbQFxb2kVddJrBALPWzK5vKJvTYjmr4XoGSxnPCIFHpMRnf/kzh75RjlHHFkDxrv/bu9/2JhL8h4Lw7q6EhVRcoq8n5sctIQCQYRAzryxDbm8CmhObnbqmHVEfLnRu9fllf6MVkAQRiMAMsOMZM7/oquWcj0zWhzb8NUH0sQ/d+8x3m5EGFEXX5/XLg/fctM8Y3N2dUHZfj20GemxWUghtmAyHI66731sTm+db3De367nthVdPHXI4x0SAEMRaGzO76NL8oisyWd+F4Hs/fO+RfeXYtbQA8uLkwU/8wEYm968SlrozlZDYOBDXMUtKX3NhQK3o+FaAX93FcOECX/UezAABUhI8T+uJGUdmsj5yrnnIF/i5j/7+ofFGi6DmAnh0+FZ12/7H/L/8+Nv22JL/MW7Ljev74v5Ary21YTImGvDR9fwl4JsCv/hPBkgEEmF2wdFn51yVc/W4Zv2jH/mDZw8OD9+q9u8PvIZICyC/ah78+Nv2sDAP9SStvi2DST8Rk8rzubPAtz2JnQO+qfswt6FqWge+2mxz0TQqRcg62h+byqr0sjdnYO78yB88e7CWJBAVNx8eFneNjOi//thb38LCPNSdsPou25DScVsqtwJ8Dv+rHHTkXV9kJDa6T5RrEOmaKO/UuE/RmNHEeLgMvijinqsAz2XLqPgaIsDzGTFbqq0bkjqVsPoI4qE//tj1b7lrZEQPDw+LuhJgeBhi337w391906AHPN+bsgYv25DSUgmpNYOo83q+VUOttWu4vWe14c/XkpLt7Pha7zEDQhB8rfXrE1m5lPGmUsK97hfv/e7U8HCpd1CyIq45upfAgMv8YCqhBresS/pKCalNMfiVuz7qzmx2x7cqBdrZ8VXvU2fcUXZ8FPCj7HhEHDMI0MZASSE3rov5ibgaXDLWg8zANUdLN70ssfj3j+jtzluHUwn58+v7En5Pl6X8cOdzhyJhl1y65nd80/PBDAKgDWDbUhCx73l85RNf38C/8Ofjjx44sFeOjBzlggrg4WFB+/ebBz958y6jzQvr+my5bX2KPG2I2omrX7LszznwqCIRlCQenczy2YWcjil57Yd+75mX8pgLANiXjzt7+r6upLQ29MVZG0NoycAqFZmrK9obC/emVE1bRik3ZeBV3pdb/+5l4y438oxhWtdncyphWcuOvi/AfH/w7/lgz5f+81tuIxaPbFob1+v64tLzS42+Sy7duXXp2jVKyyFRinB2ztETM45k5tt/495Djx44sFcKjAQXOQ5/KpWU6Ou24RdZ/JdcuvPj0rVqlFZdPAT4mrGm20IyIeB4+lMAMDIyEtgAB4bfcXXGdZ4fWpsUm9YmqHqw55JLdz5culZ2fHXXkCEVYXImxxNnc0YJvu437n32qACAtOP8bG/Kln3dtvZNJfiXXLrz49KhhR1f/XsFmBrD6O22dHfKkr7BzwKAODB8ta01v9eyJGxbCObmDTysijEXzbLv1CRGBZ47BHxTBl6LwKPs2YaBmCWEpQR8jfceGL7aVlndfQVJsyMVlyCQyGeYLrl0F4ZL19rza4TnA4NAJOMSJLBjWndfobTmW5IxFUvEpDHMgqk83H8J+FazdM18d8ONx0zUPPDF1xEBBoxYTJhETMVyjnuLMoZvsi0B2xKVqf1LLt2qG3gB+AxL1b6GCNAaMDoAqFngy2lqMUuwrQSWc/5NyhhcoyRBSgpy/Ku041fdsm873HzuLXsC4HmMtWsJ112vAF19lxsGnjnkIZ0BBLWXhmcGhCQSEjBsrlEgHgqvotV26YgE8qS2/LtUPB0UjJCZo+vQcMxEAkxUWOZU/AQCiBnMJvLuORcuHQOQEti5Q8KyAegqF1vA7CRjcQmwLBTmrnUsGPkoDwFDSpAYsqWAIJCuSu/qBPASzBq+twyjPYAIRAIEWrGt2QSBGSEhVAxEsv69Q4VFJGGMD9/LgI0PkAgWWsHw0UFyRNqQVjx4JpvzZ+AVFizguMC2rQLd/QR2AlZPuQYmBsYmdNtp+Py3ZQ6m37IIJMSQMiaYyQpOZyfEf7gjPWcR0kqie8O16Fp3FRJ9W2En10KqOBgM4zvwsnPILY4hM/MK0mdfgu+kK+Vh0SQSCRij4TmLsBJr0LdhD7oHr0ZizRbYiT6QtGB8F05mGpnZk1iYfAHpsydgjAdld5VIofNh2WsDxOPAjisk2K8EHwBIAu4yMDXNkJIDQ7FF4Ku5i8Ywqzz4HTfwSICNB2M01l/1I9hwzQeQWnslorycpUk8/39/Dd7yLEhaBXG5snskfC8Daaew9fv+Azbsfi8SvVvq72Q2WBh/Dq+/cABnTz0GoeIQQoXS4Nxm6YgA3wOu2iVhJwF2KyUvc7AAps5q5FwuEv/tA1+MkuLVsOyJYLQHoWLY/c570Lft5qIvposKJriCmEQkYafWQqhYKObLDDyScJ1FrNl0A6685beR7Nu+AhPXpsETSazZdAPWbLoBEy9/HSee/ByMdiGkXfhcp1y6er48EeD7QH8/YWizAHtVBV0oJoDRcYNmk3IcqcoheKliKIpVQFtSgQHAYOc792HN5j1g44cGYKD3IUSNbarBMGDtgU1orhTtHiIJz1nEuitux+4fGoaQFtjognEZWpGhDbCi6ws2QQj0hp3vQqJnCM9//WMwXg4k1cpiOwcxe2Zg1w4JkgB71e0uUkB6kbGwyJASEcV/tDEXvy9aCeXWC50SSWh3CYO7378CvlChkuOCssvOn8HC2BHMjx5C+uzL8HOLAMnA+BPBtVQk8ogEfDeNNUPfh93vDMFnDRIy9CxMYFiSLMxoye+h3UAkwMZH74Zrcc07Pw3DBqXh79XL0hEBrgsMbRJYM0A1dz9zQNYbmzBwyxYIR+ATRKbo5SUAqkiAluvrWEOoGAZ3v2eFsF5QaoT09HGcfOo+ZGZegfZzADOEtKHivUgN7MDgjh9G/7abQULBgEPSIsEYHyqxBrtuvwdCWCHgsnBvIoGF8ecwceIhLM+9BmNcWLFe9A19PzZe9X4oOwVmBhGBhAIbH/2b92DbDR/EyYP/A1aiF2z0qmbpjAFiscDwq3shAdoFJqcNpKyt+1tVUcWAq86mZwlsPNipdUj2bg38jQL4gO8s4qWH92F5/jRUrBfSShZEs5edx+xr38LMqSfQvf4a+E462N2hNeQ7i9jxll9CvGtDIPaFLHyWSODVp7+AM88+CNYaJFXB3Zs+9RjGjv8T3nTHZ5Dq214qKdhg2/U/hYkT34CTmQQJuzk3q4l4PRHgegH4ie7A8Ku1+8kC5iYNFpcYyqqIcbUHfFHJJZergLazdBQAImNdIGUXGXjB4vCyc3Ayk7ASAwWjjU3opwsFaXdBxXuRnjkBz1kM4gcgGO0g0bsFG3a/L7xWlID/2uG/wamDD0BZKViJXigrCWkloOwUYsm1yMyewgsP3QPfWQpskFAaMTOkncSm3e+F7+UAIVYlSwcCPB/o7QG2bWtg+IWvsSlTR9RzU5nF8n/k8sKQVvP5Nd8JQS1xCZkR79mMNVveilx6YsUgLPpizKagQkABGCQEtJfFwGXvCMR4XtKE4GdmT+L0ob+GnRgI7mF0eJ/gRxsPVnwN0jMncOb5/xkAn6fFh5TXdZfdEsQGQhUQhX/XbHqWmbHjcgmh6n+QJOAsA5NTK+I/CvCICHz5NaITwHNRulEIBXd5Bl5uIXzqSuSLhMTO2z6JTdf8OLS7DM9NhyDLkqBwsUWejw72bdlTPqXBTjn2j9DeciAVahBRjfEh7SQmTvwztJcNbYcVbyG5ZhsSvZuhdaVcjkK8rAc8URDvXz8osH5T/d3PHBD1p89q5NzAfOIWSa7VxH21z4hO7PiS34QFZ3kWC2OHi1yxFVWg7BR23vYJXPv+P8Xay38QYIaXXQiuKwr/FtITxocV70Gq7/Ig9Js3C0mCjY+5scOBxCjy5Su/h4GQFnLpcaRnXikKJYdqREgk12wNwtQQbfHvyufDMEMqYNeVEpF6d2jg9XFTFJttA3hubM+JzhMvGUJaeOO5v4PRHkiIikUANujddAOuvuMzePMHvoih638CQtrwnIVQ9If9ZyjYvSq+Bnayv+gWwZOczDSc9DRIWDDMDdg4Alq7yMyfKS+pBADEU4OB2qDOAJ+nYXkecPk2iVQvgXV93U8KWFpizC8aqBLx3xzwVfpqlMR6it8T6DD/jtlAqDjS08fxyuN/GCZsRKhf81m/cFGwQWrgCux4+0dww489gA273gvfzQAwBX/UsIGKdUPIFaMyD6qXW4D2K7MoVX350EB1s3PV8IeMda2whJukYdV6sjFAMgls2yoBvz74ge9PGJ0wcL18NVZrwDdDdxOrQbxko6Hsbkwc/wqOPvQJuMtnC3q+kJ0LI4MIDb9E72bsvv2T2H3bJ4LgTJ79AFMEPpf51Tq4H0UnXhrj1jDUqcTBao1/V16pC+zcoWAlChqqge/PmJzWkJJKIn/tAN+IYKsaBQ9bpWHld+7Zk49hafo4Nl//77F+57ugYt0rujeUBkGsIEgHb9j1HggVx4sPD0MJa2XRVGlnIKQFEjLU59EYtyuLqUz1+rmWqnqqpopCn39wncCmTaKmz1/u+89MGiwsrSR+OMJAWo3Z5Ect2tnxjUqqgphAN9zsHE48+Tkc/vLP49R3HkB24Y0icogpuIokAsNu8IrbsXHXe+C7SxDCgu+Guf6S3QrYiT4IKxEuEGoQpg1Cw3ZyoHQthcg4y7PBmLg5PV+LfKkksHuHbOjvF6+a8SlTuGcndjxqspRLjMDOA196jQZJC1asF7nMNE4/85c49L9/AS8//odwMlPhpJfGDMCMoWs+EOxWIrjZOXjO4spdw1m1kwNIdG8EG6+CK1e5EALbpKv/8hJpkl9My4ujIFKRlGG9phgUGn5DmwR6+inI9TdYBIHvbzA+paEkVUT+orp0jWoDqqlHsWrAl+QwGSa/EBK9YO3hje9+GYe+/AuYH3s2JI6YcEMGLbBSfZfB7loPBsPLLWB57kyZ+xZkAfu3vBW+75S4kJUiWUB7DlJrtqGr/4qiGACHC2wWmfnXIJS9cv8mgS8nelx5hYoEft73nzprCr5/VJeuHeC5nhvYbi0ds4HRLiDkiksX6nljNJgIVqIPzvIMjn/zM/CdxUJULr8zhYrDivcCzNDaxezowZKn5uMBQ1f/KGLJtTDaKUQPK3elgO9msOWaHy8hgeTTxbNjz8LJTAdJpirTFQX4Qg2eD+y8QiKWBCL37DTAmQlTRvisb/21Czyq5QIapjojWJfMGsruQqJ3c+BysQ6idEShVKCCYWfFe5BLTyK3NBG+x2UVSAaGNaSKYerkozDaCYHngv0QTw1i1zt+C76XhdEuSKgwRSwLvMNsehIbd96JoaveX5pFDMcy9tJXw8XDLQHPRUSPgX7Cls0yUryfOfT9Fxhz8wZCBNRvNoELaXjlh7n675WSoTHwxQuoZjq4pSJKIrAxEFYC17/vT/DG83+P0WP/BDc7DxISJKxCIgeGkcucRd/mPUis2RqK5RUpoP0snNw8iASEimNp9lWMv/x1DF31o4VsIIXxhA073gkAePlf70d2abxkIUkrgW3X/TvsfvtvhvdHkQqRmB07jOkz/wppdxUFrFojXhpm7N6h6hI9qqUJx6cDVzZmBeBHfTYRQWuGrwGi6GMufl9xBJ59c65GkBJWdjcuf+uvYePVH8D0qW9ifuwIsgtvwPcyIBCsWA96r/oRbLvxZyBVfCWdzAYEID13Ck56EkLFAilgJXDy4F9g7dabEUutK0rrriyCgc17MP3at5CeOw02PuKpQfRv/n50D+woY+NzwCbWLo5960+KwkstNr4iwHEZW4cE+gck2ONI1j8RAJ+xfYvE9i0SkV8MsABch/HEMy5Yt1aQUkUCtNPjtkhsEoHZB7OFRM8mbL3+J7H1+p+E8Z2ABAJA2amAKVTWsCyIzSu88eL/gdYehEoArCGEhdzyWbzwyKdx43s+t8IIohVJYMV7sWnXe6oSQqmIMsbMMH4OLz7+X7A4/RJUrBuGdct9gTkkeuy8QqG2CV/7ZVlNfoAB2ISjJzykswYxmxqQRmq/RKnObbXCt7Jsuthaz6dohYrBivfCivcGrBzOp405uI4NhFCYePVhjL/8NahYVyEIZNhA2V2YfeM7eO6f74HvLhfqDQoAMxc9b+W5K+CvxAOy6QlMnHwUQtmRg0jVTMN8b74dlykku0XDeH/dIEOEHzbBtp2e1Dj5ui6AH50XwCURT9FqnX/9sukg65dn3hQIHEaDjR/+6KJW2FTYyaNH/wFHH/0MhIxV+L3MGirei6lTj+PgP/4q5safK3yuOEdQhaO+YheELmdX33bsed99ECoO7Tsh+SRK2XaRogjDvWt6BLZviy7623oR4LvAs8dWYh+tAJ+/Rr7n5o37erpsdKcUjEFJa5hWaumIBIzvYHn+DISMwYp1QapEwMULdfbKT7Az3ewcZl7/Nl761p/izAt/DyGtAjG04tnGQKo4culJjJ/4OjLzrwXMn0Q/hLRrPCMwmPKcwLwHkejeiIFNN2L85KPwveUwTFyv7IrLjLDgIIfrrrLQ00tVa/s6+WIGKEZ46RUfr41rWBaBubkm94ygiWR6WSOzrEF/9KHLeNvmddi6qR+upyOUhkWrpfPdDCAkYql1SPQMId69AXayP1wMAtrPwVmeRXZpDMvzZ+BkpgAQZEjerJhyLp/8QO/7bgYkFJK9m9HVtx2Jno2w7G6ACL63jOziGLLpCbzp1rvRPbCjYDfkJRIJiYXp4zj41Y/Czc1DqmRR7qE2/y4f8ds4KLDn+6xIbl/b4CtgYcHgkadd1KsVqHfIBTNgWRJjE0s488YU6LO/uoU39itsHRoArF4IIWsUSjRXS5dn3RjtQmsPzH5IpeIC2SOQCjLYudIq4e5H9UaC5xho34XRblgAWuSThN8n0b0Re953H7r6LoMxXiGQxKwhpI2F6eP4zlc/Cmd5Jiwd05EM4B+8yUaqi1rT/U2aCSDgm0+7mFkwUHXtzRot4yjIMhp/Ca+PTmNy2oW8Y0/vvu6kQtL24DvZgFEr7XwLyTa7VAQsH6lsSBWHtOIQVgLSSkBacUgZD4DPh2Vr7HqO8GSSCkLFwnsnwmfFIaQNaSXg5hYw9dqTGNz2dsQSfSsqImQXx1NrsXnnu3B29BnkCunr2vX6jsfYfbmFjUMyUsi37d1vA6df0zhxRpeUiUU+2oYEtPaQzZyF5y0gs8zIZAvp4MAv1tqDTk9B2cnAUi8qm2q9iDJf7o3oLia30KghrzaqMYPYQNpJZNPjeOZrv42hne+ucD+N8aGsOHrXXomluZNVWTX552kNdCUJl22VYJ+rNVKpacBRC+BDApklxvOveLCq7vz6wDNrONlZuM5i4E0pWSDGFuoCDPLl1gzfTcP3srDiPVCxnoK+Xa32KKvVF6eE+GM0pJXC8uIYjv3r/UXZtVJKu5AxKCtZk1hCFIRpr91lwe4iwOWiaEqEQZvmJQAJ4NnjHhwXsEt2P9eNygIEz03Dyc2HhFdRyLZWEEKo2JcPRbKbnYPvLkPFuqHsrtCSNue1/1177VEMSFqwVV9Nyx7MlXZIhREFnH5d4/QbunRx1Bm/CbOEN1xtVSZ96op+wuioj9EpUwR+Y+B9LwvHWYDvLYeiRxaxtKngzKqVbHllaRhIwGgXzvJZ+F4GVqwXwkqEvEzTcgfxcw582awGUb/mu6EUJTUxOWNqVOygqsfgeoytmySEhegegwh4As++5Ic1Ao2B19qF6yzAddNlpXmmPN4XqABqFP8uWlHay0FacahYD4QVB0HULK1erY6X7bVHab+kKv8/paIveiJAM7B+rShKe0fY/RbhxaMe0ssGMbsGTawAvAPXWYTnZkKKvSgK6tSeMxV1MvIl1r6XhectQ1mJsL4vHipQU2dCqCzPQC0f28qgFiQOV+YcWgS+fA036jCWf7aUQH8vVdZ51+EITk9pnBz1EbOrfKwu8KIh8FyeDeSok0gECiWC7+UgVAzK7oKyU4USsMDSIYAEs9FBiIw7t+Pb6ZCBNoGv+RmhmJmpmG/ORSojbhO6khQw3ilCLaELHD7mVt2IDIbvZeE6S/D9bBHwsqYnVCtMrJrbPcVBCRGyaYMMn+ssQlkpqFhXmOVjGC9Dwu42Ulim4vzoyDu+9W5YLYPfbEaUDfnOvCRhASRLA1FhvmBtF0HZjTmC+XDvieMu5hYNYjFCMHUEYzRcdwmeuxTQ4PL9FgrAm6aPyG1ACInQaiQURaw9uHoOrrMIacVZWQlsu+6nxrZd9xOTQsUNs17tNMl5eQX1HJJHX3247+jBB7b5blqhiFzKIVFk7RoRNvnjhuHe+RmNY6c1YrGA8q6NC89Nw3OXYYy34hsWMpym5fY+iiPs+ki7YCXlyl5mkjZ//y+P7br5wycBWPjef9H2a35szE4MeAcfvntXCDPlLQ4pCANrRKRoETPhyHEN3/cBzsJ10tBhiDufUOO2z2XmgtOvGnHJmrPsCQyfVGKtvvKmX5kAYBntCyEFf6+vAGNMbOjyW+eOD+zMLJ59qYtknMGGjAFsm9DbVT9bGIh+gZdfXsSp12egpAOtdRicozBdzQ0jpdGKQlYkkeIq0Lfl0jEDQrG0EibIxQiucj7l954qYI8ABSnjprhhhtbAmiTBsgls6vQEkoTFeQfffm4UgIYxsqThJYrAb69LaIUbyB1sysyAsNhbPqteP/pP/Vfc+DOjRvsxQEAQsWHujB1AF5g5wRpSxtyFmZNdCzMvdYFsZjZEode3do0AKQK7XKc4hPDtI5PIOQZxW0FXRJm4owZxdFZwk8kaZiaSNo49+Udb492D7tCV75qreU7t98xLYmH2ZNczj+zbYbQrQvEfZFiMh/5eWUdyMMhWOH16Hq+NLiFmi1LwIwLflAfXjBsYGfjiv5GC76bVd/7hl3f3DL4pbVkJbdhQq2FjoqCoU8hYgfdPJMPiUpRkGrm47juiO0d1SBVcccpucUpvhWQ6N328W/sZAiS0O0Nae9DagYDBmu7Laut/IZDNuHjq2UkIVVQV3LKBF72zadVIILUMfPkZNQpECouTz3cxTHOt5qp9FeaCy0kkCjwCIa2QVBJUEouQaRwUhYhSyUYUsdVdGcmVDUyowIMuIgxjfBjjQ2s/ILtAhv13/TC9HpzU1debQCJhVc0CGmYIW+LQM9NYTLtIxBSMMasKPGrVBXDHT9YKs4YqwVRnkTWKxFRVSRy0XgnKxpwQ2OwKQyhMggTU8ZV28kLakU4KyYNbaHubJ7ESBcTWvFkWcgwDq9rQSnFLYLlrozE4kICwJYzjQ5QUpgDClhgfXcLxU3OI2xLGmFWLenI1elhNFdDJI9U42gmkNdOzDT5HxSVdzGD2AkDYDxZHm0fEcL6CmKjQor7qs8sJo+F41q9N1uCyAZ6j8eSh8cL5CHyOIp7F3KuyXsGl7Vk7ceLGambpuCgKVn4ERX4XclkxOFdJCXHhk1RT83NZgwrOV3XWGKNmA9uWWNcfB7Qp2f2GGSKm8MKRCUzP5ZCMq0CinUPgS+IAha4GHPTSaS24UPea/FlkXGI8tRT3pwojr7lFVvxsLilJbq4tfH1JpQ3Qk7LQlSzV/0GYRGJmOoMjx2cQj8kC+Lzap5SAK7KxChy9V3CzwBMJw6xFfllR0dkEXAolUMUir2WlE3NVndZidjEEX+ZngloFnksOeWIM9MUgYxLsFrV8p8B2ePKZCfjGwFaiaoaYO3pmAbdQHNrejg/fzAqIlC+E8jnULlQmTLnUwapEpkyn1roGVU4fqC7uSz+TrxcxejHGUGDIhhZC411HMHn9TxQudgrDvRLHjp/F2HQG8biEMasJfGPpqlZJzzPBYGjXv3n66rd/9IhUSW1Yk2iQDl71eH1ZMMoPI5NKWualZx/cceyZB37Q97JxBIuAWjFK8400bCWwYSAB6BXwg3BvDk8/PwXLFiXgn2vgudqBER0x8EgYwVmxaecHnn7L++77OoDURRDKoze//aNPJ1KDy995+O4fY4iWgC9KDCERU+jpCqg8lO9PLQlPHZ5A1tGI2aJm25e2mNVo7lhf1WHLnom1YJHyrnnHRw4DSPm+q5SyjTHmguQDCCHYGEPGuL273vzBV178zhcnM4snNzBsXpECTfD/wGEAKAYVU2A/PLXEVjh1eg6nw3Bvdb3fCQMveqNIrp0LaMelMyCSxrK7/aDZd+BoCHHhpoSDRRBEc6SMeS01iggN04C5w9iwNgmSBOMxSAbh3iePTEKUNYE8l8BHIIS0E3/OW9CSoRdjLx/52yuvfcdvfRvG7TWRKyfOVy7fJ6XimanRQxuXFl7dwLC4ljdQC/hiMKUkbFibBEzwb8ISOPjM1Eq4l/n8Ap93+ZlW6gI6Rb7Mlxu8cvgvbk12b0xfcf1PvnKhGwBCKJ4aPbTx8f/34fcZ41qAzQ2NsBpZOm0Y8ZhCf28M8A2kLTE2uoSjJ+cLPn8nXbpW6iLKWMFcOxfQWvyZGBLayyYOP3z3vz1+8IFxqWIuGyO4ysHUzTF1KbJ6ilI2bYrcwKX5U0NgR5hQ99fdPXWyllozerps2LEgOeS5Gk8cGi9EPrgDBl4ngG+CFdyKscIwkAAkLy+c3FixULgybs4djEG0snsYFrgM/KjAF7ew9XVe/weFGc9/dwJT81kkY62EezsHfIus4HaMlcApDHZUtMGsXgg0in3DVFXvNxGmNWAIIqwfSACWwPRYGoePnw0yfS3l99vT8y2xgjuve5jOBbkBHfenm6dhMTPiMYn1/XGwZ/D44bEmw73nDvgmCCHcsTNzVyPczBcA8MUGYE9KItkbx7FjZzE2vYxEpHDvuQO+rgpYJeD53Fq6LS46bhj/oPqtagDPNxga7EI24+HJ5ydg27JBuLczvnwzqrXcZVXN6trmdjwZghF53h41yNlFYQtVv4YbXlNNulHxmKl+cokhTFD7B6o2X3kuweb1KTx1ZBxZRyMRkw0ObuqMS9caL4DLcwFcM0XbqqhX0hM+2y6R8ogrDSyqmMTq6WFUPWe8MrvNETKElYsh6Gxac8EEXURIIJswkMgz28un3tcGPV02ZhcdnDizEPr858eyjwJ8iRHY1kqsDj6DGAObb/3KDbd8/BFld/kGPnWeGG5aJ5ubiL1aRNBI5fmDX3zzqy8euMvXTooL9IZifydo3PzcyzNVacbnG/iq5zwWF4Y0TQipadmTUdIT/UO3fPW2vQ/+FYA1TXA3Lthg4Q/c8ftfTaXWLR759h//BrOocUiUCYtFqQZT8NwapVFUevOEkPouHRMZwRzL3XDrf/oXAL3ayykI6+KvDTTOwI1v/80jR5/70mknO7FdszIIVkJJHz+q2kf5wgO+aiSwUy6dgTB2asAFICAsllJe9AvA87SQFgwJy4kG6vkCPppKj04Iac6XJ4YwCtnki0/9txtvuuP3v2KMsxZGsBQXT4WwrswWCivevXD6lX+5PLs8frkxirlmvuDcuXStxD+qqoCOBnGYSUPg9NH/tTfVs2H+TW/99WcvNv0vy+s2pW3eOPnI9ie/8Tu/yOzbBoqpImdw/ly6ZmM2JWUAn/qVjTw4YGH9Wgu+zxUuVauhW6LgXnZy/SmSdg5sBIWcQK5hzzffkbTo06bVdnPVwz9l46F0evxKQb4wRlVhCvFFAXx4Ug+UAs7O+JiZ8YskQP7cAOpMzN4wcdAKfmI7gRtk+5pfwY0ieB3PM7CC4XLwL0zgo9smeULI6iRrKKiQUabz1UBlhSF0LqqYWKzo/QvXso8aJi8qDGmVEBJx9xS5SquWrGGc48qaix/4NgghF1+W7uIFfnUSYxWsYI5ECGkH+It191zYLl0n8gyKyyLAFyPwq11Ld6Fb9s0CX1zHoYQoBZ8uhEk8bwyii8ula2XMxS9BIGU0Rl2fhwxzmBU9jzrrEvCrL12Dvt7s+0zamFHFwCiAoZCrSxcf8KtbS3cxWPbNjRlg4rCxNUYFCbyotYGvmcuPImt8iGLlsZHNHTxZm68e9fTOerXvUbtkRP+uRWPm6CeL1zuMvp1TWpsac0haZWJozaw1gwReFELgaddneD6o2kmUaAL4i2MSzxfwOG/A58eNlWPuyfMBQDytFOPxnGOcnMOxoDV57dNDL7l0F7aB12jMeR2fc4xwHONISY8LPdj/qmF+JetoADD1z6Nd/d2DCDu+OVXDdSNhUXdP0+K2bSlZ61zmCPepMeb8CXmuAzDTK4ODs6+K/fuPulKKr3g+w/HYEHV4Eplr7h6OQFuu1+c22iSio5N4QQOf1/M1rgmOu2Xj+QyS+Mr+/XAFACQk/ia9bPRSWktBxceRc+uTWAQ8nxfg+YIDvhmjtGkpWaTna50ZDALSGSOXs0bHLPwNAIi9eyHvuX/iqDbmiaxjyDNGB+2czgfw6AjwLXsjzKvqjdQ38NC6Zc+N5wzBgZfacZi05ifuv3/26N69kGJvPiZs0aezOcZiWkOKgDhwyaW7wF06jrZZmAEhgHRaI5szEEp8uhANvGsEengY4nfvn3zU9cw3FpeMdHzWQlxy6S50ly7qZiEBeD7rpbSRns/feODzM48OD0OMjECX5OplTP76cs54s3OaQlPgew/4Oi5dq/GP6Pepb5usljdCBJ6f1+Q47CkSv17Bf3zsMfCBvZAf/sul6R/Y0yXAuI0kdCImhQmPObmUpeOLLs/AzJASWFoyOpNhqTV+94tfmP3y3r2Qf/ZnAe2xxOnbuxfywAGYez604aFEXPzw+kHl2zYpbcoKKS8la1Z/zGWdVFoJfAkBuB7701Na5Rzzzw98Ye7Ou/YGoh/VTnG5eiQ4/Y0t89PLjpmamvGV77MWxGBzyaW7UFy6hoEv5nzIV8/MGOW4PJWwrZ8mACMjpR8rWQD7ATM8DLr3vqlJLfj9y1k9Nz7lSd9nLWTpebmXXLrz59LVs02CjqSAr6Gnp7XMZs0cGbz/vvumJoeHg16IqNFruUQVjIxAf/xXN+whwQ8lE6JvsF/5ti2UrxnlWcNLxMs2eyxyh+wiBoQEPJf92VmjlrNmjkF3/vnnZw7mMUVl8XPlayRwDdUffH7iIBu6czlrxsemfbWQ9n0lKTiQgy+5dOfDpav2xHyUT0jw0pLxp6e1yubMeB784WGoauCjUUOOA3sh7xqB/sQvrd1obPlXtqI743GBgTVSW4qkNvmHX8rSnZc6/zzwAvB91vPzRjo5huvxQ9Di5x544Ox4rZ0faQEUqwMAuPvX1u8zjLsTcWF3p8h0d0uWgoRhpnxhEeiSS7eqYw47GVJ4jJExMEtLhjIZI3I5dkF8759/fm5fOXaIVgdZ+Tp6FDw8DPHNbwLvfG/mm7e8resffM9szzpmp+Oy8HwmpciXivInylNp67TGhmFDEUglJUF12qxHMfDQhmWPBodLlTW8DI9I4bCKqfyaWp8ruYZKj6InASYC+z7rpSWWC4tGZNKGfB9fk+C9D3xh7kB4robI+/r1Xk21cM+rBAC458Pr7vAMfscYuj2VFMKyCPEYIWYLoxSxlCAwKDglgqscXtwCZ7CMtcgNTu2oOEiylXOJmqbGU+VuLxp3s9LGmBBwHRA5XZeFk2P4PpBZNkYIfkQq+uzn75/9RtRd3/ICAIDhYYh9+4JBAcAnf3PwWs/FB33D7wZjZywmYkoRpAgKqC3VhpXM7VT8Nt61nbRNOmfVl/7m+8H6MSYA3XGMA6KXhcTXrBh/6b//17kX8qfp7NsH2r8fphk8Wz7EIR81zC+E4WEovTh4levhZoBu9HxzAwObBGHImErrIJp7FG2Y9X15avJwKW5KUlUellMsL6idUnsWAmQMj5LAmJR0BODDKoan1vbMHdu/H34e+LvuKo3uNfP6/xGzaSVXPbbRAAAAAElFTkSuQmCC"},"snippets/sql.json":{"encoding":"utf8","content":"{\n  \"Select\": {\n    \"prefix\": \"sel\",\n    \"body\": [\n      \"SELECT ${1:*}\",\n      \"FROM ${2:table}\",\n      \"WHERE ${3:condition};\"\n    ],\n    \"description\": \"SELECT\"\n  },\n  \"Insert\": {\n    \"prefix\": \"ins\",\n    \"body\": [\n      \"INSERT INTO ${1:table} (${2:columns}) VALUES (${3:values});\"\n    ],\n    \"description\": \"INSERT\"\n  },\n  \"Update\": {\n    \"prefix\": \"upd\",\n    \"body\": [\n      \"UPDATE ${1:table}\",\n      \"SET ${2:column} = ${3:value}\",\n      \"WHERE ${4:condition};\"\n    ],\n    \"description\": \"UPDATE\"\n  },\n  \"Delete\": {\n    \"prefix\": \"del\",\n    \"body\": [\n      \"DELETE FROM ${1:table}\",\n      \"WHERE ${2:condition};\"\n    ],\n    \"description\": \"DELETE\"\n  },\n  \"Create table\": {\n    \"prefix\": \"ct\",\n    \"body\": [\n      \"CREATE TABLE ${1:name} (\",\n      \"\\tid INTEGER PRIMARY KEY,\",\n      \"\\t${2:column} ${3:TEXT} NOT NULL\",\n      \");\"\n    ],\n    \"description\": \"CREATE TABLE\"\n  },\n  \"Left join\": {\n    \"prefix\": \"lj\",\n    \"body\": [\n      \"LEFT JOIN ${1:other} ON ${1:other}.${2:id} = ${3:table}.${4:other_id}\"\n    ],\n    \"description\": \"LEFT JOIN\"\n  },\n  \"Group by\": {\n    \"prefix\": \"gb\",\n    \"body\": [\n      \"SELECT ${1:column}, COUNT(*) AS n\",\n      \"FROM ${2:table}\",\n      \"GROUP BY ${1:column}\",\n      \"ORDER BY n DESC;\"\n    ],\n    \"description\": \"GROUP BY with count\"\n  },\n  \"Window function\": {\n    \"prefix\": \"win\",\n    \"body\": [\n      \"ROW_NUMBER() OVER (PARTITION BY ${1:column} ORDER BY ${2:other} DESC)\"\n    ],\n    \"description\": \"ROW_NUMBER over a partition\"\n  },\n  \"Index\": {\n    \"prefix\": \"idx\",\n    \"body\": [\n      \"CREATE INDEX ${1:idx_name} ON ${2:table} (${3:column});\"\n    ],\n    \"description\": \"CREATE INDEX\"\n  },\n  \"Transaction\": {\n    \"prefix\": \"tx\",\n    \"body\": [\n      \"BEGIN;\",\n      \"$0\",\n      \"COMMIT;\"\n    ],\n    \"description\": \"A transaction\"\n  }\n}\n"},"README.md":{"encoding":"utf8","content":"# SQL Snippets\n\nQueries, joins, windows, indexes and migrations for the built-in SQL language.\n\nType a prefix and press Tab. 10 snippets.\n\n| Language | Prefix | What it inserts |\n| --- | --- | --- |\n| SQL | `sel` | SELECT |\n| SQL | `ins` | INSERT |\n| SQL | `upd` | UPDATE |\n| SQL | `del` | DELETE |\n| SQL | `ct` | CREATE TABLE |\n| SQL | `lj` | LEFT JOIN |\n| SQL | `gb` | GROUP BY with count |\n| SQL | `win` | ROW_NUMBER over a partition |\n| SQL | `idx` | CREATE INDEX |\n| SQL | `tx` | A transaction |\n\nThis extension runs no code and asks for no permissions.\n"}}}